You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

@AVG in ESSBASE Clarification

Received Response
21
Views
9
Comments
edited Aug 2, 2018 2:36AM in Essbase 9 comments

Summary

@AVG in ESSBASE Clarification

Content

Based on this Oracle documentation(https://docs.oracle.com/cd/E57185_01/ESBTR/avg.html )  - when you have West=@AVG(SKIPNONE,California:Nevada) you get 155; it skips the #Missing values . For a similar calculation with SKIPNONE i get 93.

When i use SKIPBOTH i get the 155 value mentioned by Oracle- can someone clarify what is right and what does the oracle documentation actually mean.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!