We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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 of accounts

Received Response
edited Aug 2, 2018 2:36AM in Essbase 11 comments


avg of accounts


Hi all,

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


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


--A1 = 100

--A2 = 200

--A3 = 300

Howdy, Stranger!

Log In

To view full details, sign in.


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