Rich Text Formulas Using Numeric Ifs
Hi Let me first start with thanks to everyone who posts in these forums I have learned so much from you. I do NOT code but I am real good a trial and error also google. So you have been a life saver. ...
Forum Discussion
I suspect that your intermediate calculations for the values like [Final sales price] etc are not being rounded to pennies and hence when you do those subtractions, there are small decimal remainders that are not exactly zero.
A proper solution would be to check the source formuals of the values to round them to pennies but an expedient solution would be to round your test calculation
If(Round(
[Final Sale Price]-[PO Product Total]-[PO Install Total]-[PO Shipping Total], 0.01) =0,"Good","Bad")
A proper solution would be to check the source formuals of the values to round them to pennies but an expedient solution would be to round your test calculation
If(Round(
[Final Sale Price]-[PO Product Total]-[PO Install Total]-[PO Shipping Total], 0.01) =0,"Good","Bad")