Cumulative %

[johnhorneramllp]

I have what appears to be a simple need to calculate a %age on some cumulative numbers but the % is not being calculated on the runningsum numbers. I am sure i am missing something obvious, any thoughts on how i can get this done, i have attached a small test dataset to highlight the problem, though my real dataset is larger and more complex.

Cheers

John H

[johnhorneramllp]

please see attachment.

[johnhorneramllp]

ok the attachment is not loading...will keep trying.

[Anonymous]

:))))

[johnhorneramllp]

ok let's try again with the attachment...

[#6]

Hi,

First your % (Accum) expression is the same as the % expression. I guess that was a typo? That does not appear to be the problem. I tried a "roll your own" accumulation and it appears to work. You are expecting to see 40% for the "B", correct?

sum(Metric1) + if(Above(Z1),Above(Z1),0)

sum(Metric1) + if(Above(Z2),Above(Z2),0)

[Z1] / [Z2]

HTH,

David