Forum Discussion

DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago

Trouble comparing number values in formula field

Alright, so I have two tables, say Order Sheets and Order Items Each Order Sheet can have multiple Order items.  Each Order Sheet has a field labeled Order Amount Each Order Item has a Quantity...
APIs and custom code
Formulas and functions
Tables and fields
KevinSlider's avatar
KevinSlider
Qrew Trainee
7 years ago
It sounds like you have tried setting the fields to currency with matching decimal places. If Quick Base shows 29.90 in both fields and the formula still evaluates Not Equal, then I would take your formula and adjust it with the round function to round to the nearest cent. 

If (Round([Order Amount], .01) <> Round([Total Items], .01), "Not Equal")

Let me know if that helps.