It looks like your table calculation is being very strange and may be calculated using the wrong scope or direction. Should there be running sum table calculations applied to your 6 week current and 6 week previous fields?
Please could you provide us with a workbook/sample workbook with sample data? it's hard for us to figure out using only just a screenshot so a workbook is always the best option.
Thanks for your response. There should be a running sum total as I am trying to calculate a cumulative average. Let me fudge the numbers and Ill post a workbook.
Hello Mavis Liu
I added a workbook. Appreciate your help.
So your calculation is working on a logical sense:
So your test percentage works out calc current - prior / calc prior 6 week DN Drop.
So -73/198 = -36.92%
then 38/243 = 16.69%
However, are you trying to work out the difference in the RUNNING TOTAL?
If you are, then that makes sense as to why only -36.92% is correct. It's because it's the start numbers where no running totals have been applied.
If you want it to be % difference of the running totals, then please create this calculation:
Now the % is shown as:
Is this what you were expecting? -35/441 is -7.91%.
Thanks and please see attached workbook.
DummyData_v10.5.twbx 72.5 KB
Thanks! That worked. Unfortunately it's not what they ended up wanting but it was a good lesson to learn.
Thanks for taking the time to answer my question.
No problem! People always change their minds too, happens to me often!