Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Calculate a sum across years

edited Jul 28, 2020 12:41PM in Essbase 2 comments

Content

I have a requirement where I need to determine it has been 20 months since an entity has seen it's first activity (net income <> #missing).  If the threshold hasn't been reached the entity is considered "inactive" for the current year->period in which case a stat account will be set as "inactive" if has been 20 months since first activity then my stat account for it will read "active" for the current year->period .

I have a traditional Planning period and year dimension setup.  My brain is bending trying to come up with a strategy on how to approach this.  Any guidance would be appreciated.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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