Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Aggregation and weighted average?

Received Response
52
Views
5
Comments
Rank 2 - Community Beginner

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.


Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 5 - Community Champion

    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

  • Rank 2 - Community Beginner

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

    Thank you for your help.

  • Rank 1 - Community Starter

    Having the same problem

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

    Edit: MyTeamz

  • Rank 1 - Community Starter

    @Sinduja Sekar-Oracle I'm having the same problem, the inventory on hand value is being wrongly calculated in the 'Inventory Turns' subject area as the unit price is being aggregated instead of providing an weighted average.
    Did you find a solution for that issue?

  • Rank 4 - Community Specialist

    @User_8LCPT - I agree with you and we're having the same issue. The "Inventory Onhand Value" is incorrect in the 'Inventory Turns' subject area. In our case, it's drastically overstating the value. Hope Oracle resolves this.

Welcome!

It looks like you're new here. Sign in or register to get started.