This content has been marked as final. Show 7 replies
I'm having an issue with my accumulation function. I need it to include the value on the first row as well. Below is the output I am currently experiencing, however what I was expecting to see is in the "Running Total" column - 75.73% on the first row and the subsequent values adding on top of the initial value. Any assistance would be greatly appreciated.
Here is how the columns are being calculated:
Relative Total: sum(count) WITH relative option selected
Total Count: sum(count) WITHOUT relative option selected
Running Total: Above(TOTAL Column(1)) + If(Above(TOTAL Column(3)) > 0, Above(TOTAL Column(3)), 0)