Conditional Formatting

[izen]

Hi guys

I have a problem about Conditional Formatting
I compare 2 values which are foodcost
I would like to check there are the same values or not
so I use the field value is not equal to [fieldname]
other fields look good, except cost fields it shows the result opposit
for example
not equal toI would like to changeto red color if the 2 values are not the equal but it does change even the value equal.

2 values, the first value comes from calculation another comes from typing
but on the 2 fields look exactly the same to me

I reckon the vaule that comes from calculation maybe not exactly the same with the user type
something like $5.31234124 (calculation) $5.3124 (typing)
However I set the format and decimal only 4 positions
so on the field I see just $5.3124 (calculation) $5.3124 (typing)

you guys have any idea how to fix up ?

Happy easter !!
cheers

 

[pbaldy]

However you format the field, the underlying value is the same. I would either use the Round() function when putting the value into the field, or in the Conditional Formatting expression. Also watch out that using Single or Double can result in odd problems such as this.

 

[izen]

thanks man it works