Oracle Fusion Data Intelligence

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

Weighted average calculation in FAW?

Received Response
12
Views
1
Comments
Celic
Celic Rank 2 - Community Beginner

Hello,

Does anyone know how to create a calculation in Fusion Analytics Warehouse to calculate weighted average?

In my example, I have a table displays invoiced amount, unit price in rows and quarter in columns.

I wrote a calculation "(Invoiced amount*unit price)/Invoiced amount" but it doesn't work.

Any help is appreciated. Thank you.

Tagged:

Answers