avg of accounts

Summary

avg of accounts

Content

Hi all,

we have a request from user asking for avg of few account range but not straight forward

like

Under Account we have 10 members A1-A5 stores $ values and AA1 to AA5 will store rates

now we need avgs of $ values (A1-A5) from A1 to -1 of member which has data

suppose if data is like A1=100, A2=200, A3=300, A4=400 and A5 =#missing, So we need Avg from A1 to A3 only

is there any way that we can do it in Essbase

we are using BSO Essbase app

Account

--A1 = 100

--A2 = 200

--A3 = 300