Weighted average calculation in FAW?

Celic

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.

Shantaram-Oracle

This is a duplicate post of https://community.oracle.com/products/oracleanalytics/discussion/19421/aggregation-and-weighted-average#latest