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
15
Views
11
Comments
edited Aug 2, 2018 2:36AM in Essbase 11 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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