Why does <.3 give a different answer than <.30

[Troy]

See attached workflow.

If I have the following number [Value] = 0.3 and convert to float, fixed decimal 6.2 and double. 

the following statement if [Value]<.3 gives a different answer than if [Value]<.30

Only the float gives the right answer for <.3 (false) but if I do <.30 it works for double and fixed decimal.  Huh?

[MarqueeCrew]

@Troy,

This is interesting.  When I subtract .3 from Value (redefined columns), sometimes I get -0.00.  Those are the instances where you identified issues.

Nice catch.

Cheers,

Mark

[Troy]

Thanks but it is still a concerning bug. Proves once again, always check you workflows.  As I wouldn't have thought before to test a number comparison.