Sum if Agg not working as expected

[raceberos]

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 

[Gysbert_Wassenaar]

No aggr needed. Try RangeMax(0, sum(Unreconciled))

[sunny_talwar]

I think @Gysbert_Wassenaar meant to use a comma

RangeMax(0, sum(Unreconciled))

[Gysbert_Wassenaar]

Good point!