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

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.

Best Answer

  • Jones01
    Jones01 Contributor
    edited August 27 Answer ✓

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

Answers