Choose Language Hide Translation Bar
Highlighted
Community Trekker

## Formula for Cumulative Weighted Mean

Dear All,

If I have a simple formula as;

ADB=Sum(NetRevenue) / Sum(AdultNight) which is €70.48 = €7,646,735.88 / 108,498 in this data set.

How will I calculate the Cumulative Weighted Mean of ADB (weight=AdultNight) by Sales Date to visualise "ADB Cumulative Mean vs. Sales Date"

The formula I know can not calculate the weight which puts out the wrong final ADB as €68,51

Tables attached

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Formula for Cumulative Weighted Mean

Does this formula return the numbers you want?

Sum(:Name("Sum(NetRevenue)")[1 :: Row()]) / Sum(:Name("Sum(AdultNight)")[1 :: Row()])

3 REPLIES 3
Super User

## Re: Formula for Cumulative Weighted Mean

Does this formula return the numbers you want?

Sum(:Name("Sum(NetRevenue)")[1 :: Row()]) / Sum(:Name("Sum(AdultNight)")[1 :: Row()])

Community Trekker

## Re: Formula for Cumulative Weighted Mean

Yes it does! Thank you.

Is formula

Sum(:Name("Sum(NetRevenue)")[1 :: Row()])

a way of calculating the Cumulative Sum?

If I would change the Sum with Mean would it calculate the Cumulative Mean?

Super User

Yes.