Domo error (Warning multiple errors encountered for same location in pivot table indicated by ****.

abarrie23

I'm getting the following error in a domo pivot table.

"Warning multiple errors encountered for same location in pivot table indicated by ****."

I know it's related to a faulty aggregation due to the fixed function beast mode below. But unsure about the fix.

Jones01

@abarrie23 change the first when to SUM(case when Term Length (Months) >0 then Term Length (Months) end)

Jones01

@abarrie23 change the first when to SUM(case when Term Length (Months) >0 then Term Length (Months) end)

Jones01

@abarrie23 what does your data look like?