Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following expression
(sum(alt(AMOUNT_DUE_REMAINING,0))-Sum(Alt(AMOUNT_APPLIED,0)))/1000
33 |
0 |
60 |
10,571 |
23 |
86 |
512 |
2,827 |
1,339 |
but if I change it to
sum(alt(AMOUNT_DUE_REMAINING,0))-Sum(Alt(AMOUNT_APPLIED,0))/1000
I get these figures which are great because the zero figure on the second row is correct, although the rounding is missing on all figures. I have tried the round function but still the same values.
32,526 |
-117 |
59,925 |
10,571,403 |
22,975 |
85,759 |
512,471 |
2,827,071 |
1,338,635 |
Thanks much appreciated in advance.
Re you using the expression in a straight table? what is the number formatting used on this expression? may be its just a display issue