Is your calc name correct?
In the example you give, you're asking for
SUM([Diff-Bud/Res-Calk2]) emphasis on number 2
...While the calc you shared was named [Diff-Bud/Res-Calk] (no 2)
You might also be getting into double-aggregations. If [Diff-Bud/Res-Calk2] is already summed, Tableau may be getting cranky because you're trying to re-aggregate it.
I recommend that you try copy & paste your [Diff-Bud/Res-Calk2] equation into the Select equation, rather than referencing the calc itself.
Naturally, we can tell you more if you share a workbook
Hi, Thanks for replying!
I tried writing the [Diff-Bud/Res-Calck] directly into [Select-Bud/Res-Calk]
but it still doesn't work. I also tried using window-calculations, but that
didn't work ether. Here is my workbook:
On Mon, 9 Jul 2018 at 13:48, Michael Hesser <email@example.com>
test4.twb 223.6 KB
Hi Herman. Please save the anonymized data as a .TWBX
A file saved as a .TWB doesn't include the necessary data files.