How to restrict negative values while using disagg operator

[former_member592681]

Hello Experts,

We have a Disagg Operator copying Actuals into the future but we are seeing instances where we have had negative actuals and these are being copied into the future baseline. We would like the operator to skip if the value is negative Can someone advise ?

Thanks,

Kisshore

[Irmi_Kuntze · Accepted solution]

Hi

I don't know any automatic out-of-the-box solution such as a setting like in APO "do not allow negatives"

However, the 3 reasons I can imagine that the target value get negative are:

1. The source KF1 has a value does already have a negative value on the level you copy on
   Potential solution: Create a calculated KF2 and have a calculation on the level on which you want to execute the copy
   calculate KF2 @copylevel = IF( KF1@copylevel < 0 , 0 , KF1 )
   
2. The target KF3 has disaggregation logic "disaggregation based on another KF" and on the level you want to copy you do have already negatives. Or it is based on another key figure and the other key figure has a negative value. In that case, run a copy operator with the purge option and clean the key figure which has the negatives before the DISAGG run
   
3. You do work with locking of KF values in your target KF3.
   Here it would depend on the constellation on how you may react, which you did not provide.
   You could create a calculated KF2 which calculates an adjusted source value, checking on the locked values in KF2.
   Than you copy from KF2 to KF3. The calculation logic in the KF2 depends on your scenario

Yours, Irmi

[former_member195150]

Hi Kisshore,

improvement request Option to prevent entry of negative values for editable key figure seems to describe what you are looking for. If this is the case, please consider supporting it by your vote.

Kind Regards,
Thomas