Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Avg function compared to Essbase avg function

Status
Not open for further replies.

Hurdles

Programmer
Sep 15, 2000
6
US
I have an Avg formula in an Essbase member. I am trying to replicate this in MSAS.

Essbase formula
avg(expList)
expList can be any member that returns a number, whether the list is of members from the same dimension or not

myavg = avg(Jan:Mar,LA)

Jan:Mar is the set Jan,Feb,Mar from my Time dimension
TX is a member in my Location dimension
(it's sibling is LA)

Here are the numbers

Tx La
Jan 2 9
Feb 3 6
Mar 4 6
MyAvg 4 7

As a normal average for Jan:Mar for Texas it should be (2+3+4) / 3 = 3
but since I put in the (Jan:Mar,LA) the average is now
(2+3+4+7) / 4

Any ideas of how to do this in MSAS.

Thanks
Justin





 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top