2 Replies Latest reply on Nov 17, 2018 8:48 AM by Norbert Maijoor

# Cumulative Running Sum Percent Calculation

Referencing the attached image, how would one go about calculating the %Yield such that it is based on the cumulative values for columns A and B, where %Yield = (Cumulative Sum of B)/(Cumulative Sum of A)?  Note that the %Yield values shown in the image are incorrect, except for the first Week.

MANY BLESSINGS!

Peace and All Good!

Michael W Cristiani

Market Intelligence Group, LLC

• ###### 1. Re: Cumulative Running Sum Percent Calculation

This is another of those "multiple aggregation" problems that come up on the forum from time to time, isn't it?

Only way I can think of is by doing the cumulative sums in custom SQL rather than using table calculations.

• ###### 2. Re: Cumulative Running Sum Percent Calculation

Hi Christiani,

Upfront, Hope I did not miss anything concerning your challenge but find my approach as reference below and stored in attached workbook version 2018.2 located in the original thread Cumulative Running Sum Percent Calculation

1. M1. A summ: RUNNING_SUM(SUM([A]))

2. M2. B summ: RUNNING_SUM(SUM([B]))

3. M3. %: [M2. B summ]/[M1. A summ]

Hope it helps,

Regards,

Norbert