What can be causing objects that are equal on the report to always be false? Variable1 = a calculation in the report. Variable2 = direct pull from database. They are dollar amounts that are formatted in the database as x,xxx.xx. You can see they are exactly equal, no rounding issue but when I do an Alerter or =If(Variable1=Variable2;1;0) I always get false. I have tried all kinds of formatting, min, max, etc… Any ideas? Thanks!
clpisces (BOB member since 2004-10-14)
Have you tried greater than, or less than to see where the amount is actually off? Or taking one amount from the other?
You could also try and use FormatNumber() in your formula, to make sure that they are both the same format.
David.Mitchell 
(BOB member since 2008-04-28)
Do you mean, In your example, it always returns 0? Please try formatting, as metioned by David and let us know if any issue
vigi_guna 
(BOB member since 2008-07-09)
Create Report level variable for the object coming from the database,then apply FormatNumber() for the objects as David suggested.
Please tryout this option,if you are getting any error please let us know.
Ravi.Kunda (BOB member since 2008-09-19)
Also, test for hidden characters in your data by using the length() function…
Mak 1 (BOB member since 2005-01-06)
When I applied FormatNumber to both variables it then worked. Thanks for the info!
clpisces (BOB member since 2004-10-14)