weighted average formula

settu_periasamy — Fri, 06 Dec 2013 07:58:39 GMT

Dear All,

Please see the below example. I need the weighted average based on the columns.

Need the expression for the weighted average only (Total Row - Yellow text) based on the column .

And i have attached the sample.

i tried the dimensionality(). if (dimensionality() = 0,sum(weighted average * column1)/sum(column1), 'ok').

but not working. is there any chance to sum the column values like sum(total column(n)).

Help Needed.

Regards,

Settu

Re: weighted average formula

swuehl — Fri, 06 Dec 2013 11:52:50 GMT

Try advanced aggregation in your expression for dimensionality() = 0:

=if(dimensionality()=0,

sum(aggr((sum([Column 2]) / sum([Column 3]) -1)*[Column 1], [Sales Org],WG)) / sum([Column 1])

,sum([Column 2]) / sum([Column 3]) -1)