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

Excluding negative values from calculation as well as their values from Total

Received Response
13
Views
7
Comments
edited Aug 2, 2018 2:36AM in Essbase 7 comments

Summary

Excluding negative values from calculation as well as their values from Total

Content

Hi Folks -

I need a suggestion if you would be so kind.

I'm writing a simple allocation rule that takes the previous year's Actual - Final result for YearTotal for a particular CostCenter (only if that intersection is > 0) and then allocating it out to Current -> Forecast.

However, my issue is that the YearTotal amount I'm using is STILL inclusive of those negative intersections.  Thereofre, I end up allocating ore than 100%.  Here is a screen shot that shows current and desired:

Can anyone recommend a suggestion? I thought about making new accounts...data copying everything > 0 into the new accounts, then agg-ing up, and then doing calculations, However that introduced a lot of maintenance int he event these accounts change or add or removed.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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