Excluding negative values from calculation as well as their values from Total
SummaryExcluding negative values from calculation as well as their values from Total
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.