I’m trying to create search on a saved serch, All data returns as expected except ‘pdcBalance’ and ‘bouncedChecks’ it always returns ‘0’ in code however it contains values in the saved search.

code
saved search

I tryed to replace getValue(salesData[x].columns[4]); with
getValue({
name: “formulacurrency”,
summary: “SUM”,
formula: “CASE WHEN {account} LIKE ‘%11030110%’ THEN {amount}*-1 ELSE 0 END”,
});

and it also returns 0