Hello, I'm new to Domo/formula writing and I'm running into issues on multiple fronts with a formula I've created.
Original objective: calculate a forecasted value based on stage, weight, and commit. Something like this:
If I include commit as a row, then it will sum correctly:
However, if I exclude commit as a row, then I get the error Multiple results encountered for same location in Pivot Table:
I've tried adding different combinations of FIXED and FILTERED based on reading this article, but I'm still getting the same problem (or the formula doesn't work at all).
While I can add commit and collapse the rows, it doesn't solve the error which is impacting other visualizations. Does anyone have any suggestions on how to fix this issue? Thank you in advance!