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

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

No problem! People always change their minds too, happens to me often!