Best practice for allowing small rounding errors

[SteveNewberry]

The Inc VAT column should be the sum of the Ex VAT and VAT columns. Some how this invoice uses its own special version of maths. What is the best way to keep validation but allow +- 0.01? I've tried creating a formula like AND(GREATEREQ(IncVAT,ExVAT+VAT-0.01),LESSEQ(IncVAT,ExVAT+VAT+0.01)) but this returns 1. Is there somewhere else I can put a formula that will be happy if it returns 1 and unhappy if it returns 0 or is there some other way to allow for this weirdness without removing all validation?

[BenLyons]

Hi Steve,

Updating the validation tolerance in the DFD to take these account "errors" into account may be of use here.

Click the cog at the top right of the DFD config page.

And update the default tolerance to fit the use case.

Is this what you're after?

Thanks

Ben