@AVG in ESSBASE Clarification
Summary@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.