Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
Creator II
Creator II

Expression returning -0

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.

Labels (1)
10 Replies
sasiparupudi1
Master III
Master III

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