topic Re: Best practice for allowing small rounding errors in Product Forum

Best practice for allowing small rounding errors

SteveNewberry — Wed, 01 Mar 2023 17:37:24 GMT

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?

Re: Best practice for allowing small rounding errors

Ben.Lyons1 — Fri, 03 Mar 2023 13:51:18 GMT

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