Oracle Analytics Server (OAS) (MOSC) READ-ONLY

MOSC Banner

How to include/replace null value columns with zero in pivot table average calculation

edited May 7, 2015 7:07AM in Oracle Analytics Server (OAS) (MOSC) READ-ONLY 9 commentsAnswered

I'm attempting to get a monthly average in a pivot table.  Not in the classic average aggregation, but a rolling time frame.

For example, Jan, Feb, Mar might contain 1 + NULL + 3.  A normal average would be 3+1/2=2.  I'm looking to compute 1+0+3 = 4/3 = 1.33

In the months where there are no values, I want to essentially use a zero.

I've tried CASE WHEN "measure" IS NULL then 0 ELSE "measure" END.  This doesn't do anything.

Same with IFNull(measure,0).  Doesn't do anything.

Suggestions from the guru's

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center