How WAVG works in Demantra series

Hi All,

Can someone please help with example series how to calculate weighted ASP value in demantra.

I have a requirement to calculate the weighted ASP values.

Example:

ASP is loaded from ERP system at level: Customer/ Product / Family

We have forecast which is loaded at level: Customer / Product / Family / Platform / <Other product related attributes>

Now revenue ; ASP * forecast. This will be good at the lowest level where the ASP is imported and OL is imported.

We want to show the revenue in worksheet at higher level like  Family / Demand Class

How can we do this.

ASP series has function of AVG(XX_ASP) ins series  expression.