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,51Tables attachedMany thanks in a...
saitcopuroglu
gregg_gascon
msharp
gutloja
Steven_Moore
sophiaw