I just did a calculation with your formula in Tableau and did it manually in the xlsx using a Pivot Table. Both returned the same values for me. Can you provide some more insight into what isn't matching up?
Thanks! I've been working on this all day too and re-did the same question on a new workbook - It works!
So it's not the formula, but I wonder if it has anything to do with pivoting the data in Tableau and creating an extract that is limiting the number of rows.
Any insight into that?
Glad it works
Hmm I've never heard of that happening. Unfortunately it's hard to say without actually seeing the data.