1200521 - Error when doing subtraction or comparison between two float values.

When BusinessObjects computes subtraction or comparison between two float values, you receive an error.

For example by different ways you get two variables <A>=494619.822, and <B>=494619.822. You want to compare them:

<beq>=If <A>=<B> Then "True" Else "False"

you get <beq>="False"! When you try the following formula to find out the problem

<eq>=<A>-<B>

you get (don't forget to reformat the cell so you can see enough digits)

<eq>=0.0000000000582076.

4159 , , KBA , BI-BIP , Business intelligence platform , How To