numbers should equal

Question

I have a CheckBox Formula field that compares Field A & Field B (If Round(FieldA,.01) = Round(FieldB,.01) then TRUE)

The Table is displaying Field A = 24.60 and Field B = 24.60 -- but my checkbox field = FALSE....

It is likely a rounding issue -- but I'm including the Round() function and still getting FALSE ---Any suggestions?

bradelmore · Answer

FYI:&nbsp; &nbsp;I got this to work by converting to text --- ToText(Round(FieldA,.01)) = ToText(Round(FieldB,.01))&nbsp; -- It works -- not sure it this is best practice -- any input is still appreciated

quickbasecoachd · Answer

Can I see your actual formula?

bradelmore · Answer

&nbsp;I got this to work by converting to text --- ToText(Round(FieldA,.01)) = ToText(Round(FieldB,.01))

alexcertificati · Answer

What are the field types for FieldA and FieldB? Sounds like they're not the same, so the values they're producing aren't the same until you convert them.&nbsp;

Forum Discussion

numbers should equal

Related Content

Jinja If statement equals field value

Roundup whole number

Calculating number of days between two date fields

Add hyphens to phone number field

Reference Numbers Displaying Instead of Names in QuickBase