can you share your formula?
# suiteanalyticsk
KevinJ of Kansas
08/28/2019, 5:57 PMcan you share your formula?
b
Bill Gaertner
08/28/2019, 6:08 PMone field is just getting normal {amount}
Bill Gaertner
08/28/2019, 6:09 PMother is getting only amount when a checkbox is checked: round(case when {custbody_omni_created_from_po}= 'T' then {amount} else 0 end, 0)
Bill Gaertner
08/28/2019, 6:10 PMthey both add up correctly when grouping and summing on those fields
Bill Gaertner
08/28/2019, 6:11 PMbut I'm getting errors when doing something like: {amount}/(case when {custbody_omni_created_from_po}= 'T' then {amount} else 0 end) and having that come up with the summary results as a calculation between the two summed fields
p
pmendola
08/28/2019, 6:13 PMsounds like you might need to wrap the denominator in a NULLIF
pmendola
08/28/2019, 6:14 PMalso you're ELSE is telling it to divide by amount 0 which would give an error
a
AK47
08/28/2019, 6:14 PMthat formula has a divide by 0.
g
Gregory Jones
08/28/2019, 6:14 PMneed to wrap numerator and denominator in a SUM(), and wrap denominator in NULLIF, like @pmendola suggested.
a
AK47
08/28/2019, 6:14 PMexactly
b
Bill Gaertner
08/28/2019, 6:25 PMThanks, guys!
Bill Gaertner
08/28/2019, 6:41 PMThat worked. In one attempt, I was trying to remove possible zero values in the denominator, but I now understand how nullif does a good job at that.
👍🏻 1