Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
@AVG in ESSBASE Clarification — Cloud Customer Connect
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
edited Aug 2, 2018 2:36AM in Essbase 9 comments


@AVG in ESSBASE Clarification


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.


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