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