Aggregation and weighted average?

Celic

I am a newbie to FAW so seeking for help here.

I am trying to display the weighted average price for products but have no idea how to achieve it.

In the below table, I would like to aggregate invoiced qty and $/uom by month, and $/uom is showing weighted average price.

For example, in Mar-23 New Zealand's invoice qty should be 234+37+498+2899=3668 and weighted average $ should be (234x369)+(37x371.05)+(498x371.05)+(2899x371.05)/(234+37+498+2899)=370.92

So, under Mar-23 for New Zealand, it shows 3668 as quantity and 370.92 as price.

Any advice is appreciated. Thank you.

Sinduja Sekar-Oracle

Hi @Celic ,

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

Please provide more details on which Subject area you are using. If you are using "Procurement - Spend" subject area from FAW, then check if the "Avg Invoice Unit Price" metric meets your requirement for weighted average.

If that does not help, please open a Service Request through My Oracle Support so we can better assist you.

Regards,

Sinduja

Celic

The subject area I am using is AR Revenue. Trying to pull the weighted average from our sales history.

Thank you for your help.

User_Q29EU

Having the same problem

———————————————————————————

Edit: MyTeamz