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

YTD percentage

edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

YTD percentage

Content

Hi

I have a dynamic Version member called YTD with the following formula:

@ACCUM(Working,Jan:Dec). 

But I have one account that I wish to calculate differently.

I want it to just calculate as if there was no member formula. 

The problem is that it is a percentage which is accumulating where I'd prefer it to calculate two other YTD members in order to get the right number. 

Another way to look at it might be to take the @ACCUM(Working,Jan:Dec) value and divide it by the number of the month.  ie, September would be 9. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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