Oracle Fusion AI Data Platform

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Weighted average calculation in FAW?

Received Response
21
Views
1
Comments
Celic
Celic Rank 2 - Community Beginner
edited Aug 13, 2024 7:37PM in Oracle Fusion AI Data Platform

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