hi, what is wrong with my formula? (SUM{custbody_...
# suiteanalytics
a
hi, what is wrong with my formula? (SUM{custbody_taxamountoverride}+{custbody_taxamountoverride2})/(NULLIF{taxtotal},0)
s
Open brackets go after the SUM and NULLIF not before
s
Also, looks like you might end up dividing by 0 if theres no taxtotal
a
thanks both
s
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