Create the formula in SAP WEBI

[guozheng_chen]

I want to create a formula, please check below example:

request formula: (20000*750+15000*700+10000*700)/45000

[vishalakshmi]

Hello Guozheng,

--> go to data tab --> create variable(for example name :weighted average) --> and the formula you can write as below

=Sum([Column1]*[Column2])/Sum([Column1])

This formula calculates the weighted average by multiplying each value in Column1 with the corresponding value in Column2, then summing these products and dividing by the total sum of Column1.

Thanks,

Lakshmi.