Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to all im just wondering whats wrong with my set analysis ( see the attached pic)
my expected output in the top table should be
MYR 4,427.78
SGD 8,330.63
IDR 0
THB 0
PHP 0
thanks
No aggr needed. Try RangeMax(0, sum(Unreconciled))
I think @Gysbert_Wassenaar meant to use a comma
RangeMax(0, sum(Unreconciled))