hi, what is wrong with my formula?
(SUM{custbody_taxamountoverride}+{custbody_taxamountoverride2})/(NULLIF{taxtotal},0)
s
Stuart Anderton
12/16/2022, 9:23 AM
Open brackets go after the SUM and NULLIF not before
s
scottvonduhn
12/16/2022, 4:00 PM
Also, looks like you might end up dividing by 0 if theres no taxtotal
a
Amtoj
12/16/2022, 4:19 PM
thanks both
s
scottvonduhn
12/16/2022, 5:19 PM
nevermind, did not notice the NULLIF next to it, which fixes the divide by 0 problem. I do not know what dividing by NULL does, but maybe just returns Invalid expression