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.
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?