-
1. Re: How to get a percentage from two measures
Mavis LiuJul 10, 2018 7:48 AM (in response to Riaz Khan)
Hi Riaz,
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,
Mavis
-
2. Re: How to get a percentage from two measures
Riaz Khan Jul 10, 2018 8:00 AM (in response to Mavis Liu)Hello
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.
-
3. Re: How to get a percentage from two measures
Riaz Khan Jul 10, 2018 8:13 AM (in response to Mavis Liu)Hello Mavis Liu
I added a workbook. Appreciate your help.
-
4. Re: How to get a percentage from two measures
Mavis LiuJul 10, 2018 10:07 AM (in response to Riaz Khan)
Hi Riaz,
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.
Mavis
-
DummyData_v10.5.twbx 72.5 KB
-
-
5. Re: How to get a percentage from two measures
Riaz Khan Jul 10, 2018 11:39 AM (in response to Mavis Liu)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.
-
6. Re: How to get a percentage from two measures
Mavis LiuJul 10, 2018 11:49 AM (in response to Riaz Khan)
No problem! People always change their minds too, happens to me often!