Decimal Issue

[zqlcancer]

I am having issues with the decimal data. As you can see from my attached workflow, column 'round' should be equal with column 'tax'. But in my formula, number 3 and number 4 return false data, how can I fix it?

[Fazalrahman]

Please find the attached workflow

[aatalai]

@zqlcancer try this

[Raj]

@zqlcancer 
hope this helps.

[danilang]

Hi @zqlcancer 

Look at this post.  It explains why you're seeing rounding issues and gives a few ways that you can work around it.

Dan

[apathetichell]

Want to see something cool - try this:

IF round(round([Sales]/[Rate],0.1)-[Tax],.000000000000001)=0
THEN "ok"
ELSE "Wrong"
ENDIF

Then try this:

IF round(round([Sales]/[Rate],0.1)-[Tax],.0000000000000001)=0
THEN "ok"
ELSE "Wrong"
ENDIF

[zqlcancer]

Regret to say that current solution does not resolve my issue. It looks like we need accept a very small amount of difference in some cases when using rounding. Look at my example below,-58.305 should be rounded to -58.31. But it just does not work in my case.