Fraction value issue

[soniasweety]

Hi All,

rubenmarin @Vegar  

i am using  indicator image in text object with below expression.  but it is showing wrong   

using below exp:  

=if((sum([ YGross Sales])-sum([ EGross Sales]))>0,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

if  differnace is  zero result  it will show Up arrow (green)   if difference is  negative value it will show  down arrow(red)  

but if i see the difference  in excel its having fraction values   very less number  its showing  red 

  i want to  make it zero  how to modify ,my expression.?

[Vegar · Accepted solution]

Your explanation isn't very specific, but I'll try to help you.

In order to get rid of your fractions you can use one of these.

If: 
sum([ YGross Sales])-sum([ EGross Sales]) = 1250.691

Then:
floor(sum([ YGross Sales])-sum([ EGross Sales])) = 1250

ceil(sum([ YGross Sales])-sum([ EGross Sales])= 1251

round(sum([ YGross Sales])-sum([ EGross Sales])) = 1251

round(sum([ YGross Sales])-sum([ EGross Sales]), 0.01) = 1251.69

[soniasweety]

Tried all those options  still no luck     now you can seee  below   . indicator is showing down arrow as it should show UP green   as   differance is  0 in 3rd column value. 

[Vegar]

What happens if you increase the number of decimals in all the three calculations. Or if you check if value 1 is equal to value 2?

-81.0=-81.0 is it true or false?

[sunny_talwar · Accepted solution]

Don't you need your condition to be >=, instead of just >

=If((sum([ YGross Sales]) - Sum([ EGross Sales])) >= 0,
'qmem://<bundled>/BuiltIn/arrow_n_g.png',
'qmem://<bundled>/BuiltIn/arrow_s_r.png')