converted 2 decimal point number creating wrong result at calculation

[venky77777]

In qliksense I converted val1=0.00000052 to 0.00 and val2=0.00000045 to 0.00 using num(). but when I apply condition in table that if(val1=val2,green(), red()), I'm getting only red color. After converting both are 0.00 but not getting green color.

[PhanThanhSon · Accepted solution]

Hey,

The `num` function is a display function and doesn't transform your data; you would indeed need a `floor` or `round` function to compare your numbers to specific decimal places accurately.

best regards Son

[venky77777]

thanks for reply, now got result. but getting problem when comparing 2 values like v1= -0.3 andv2= -0.4 both are getting equal as round converting as 0.00, but I want separate colors when I apply if(round(v1)>=round(v2), red(),green()) .

[PhanThanhSon]

Hi,

you need to round like this:

Best regards Son