cancel
Showing results for 
Search instead for 
Did you mean: 

Force a Key Figure to throw an ERROR on negative value (in Key Figure Calculation)

vincentverheyen
Active Participant
0 Kudos
511

Not talking about formatting here in the Formatting Sheet, how can we restrict a Key Figure, via the Key Figure Calculation settings (a Key Figure, which by the way, is not an Attribute as Key Figure based on a Decimal attribute which could be restricted in the Attribute settings to positive values only) ... to allow to be manually entered only postive values, otherwise throw an ERROR?

The following formulas would default to value 0, if the KF1's value is negative.

IF("KF1@PL1"<0,0,"KF1@PL1")
or
IF("KF1@PL1"<0,NULL,"KF1@PL1")

However, this is not what we want.

We would like something as such, but this formula is illegal syntax (since ERROR is not accepted by SAP IBP):

IF("KF1@PL1"<0,ERROR,"KF1@PL1")

Is this possible somehow, to force, via the Key Figure calculation, a value to not be able to be saved in the Excel Add-In?

P.S.: If you would like to do this via Data Validation in the Formatting Sheet, it is possible. See Data Validation in the IBP Formatting Sheet (allow whole numbers X and X, otherwise error message) |.... However, the current question asks specifically to do this via a Key Figure Calculation.

Accepted Solutions (1)

Accepted Solutions (1)

guglanigaurav1987
Product and Topic Expert
Product and Topic Expert

Hi Vincent,

If it was a stored key figure, I would have recommended using the 'Fixing of Key figure' Functionality as that doesn't allow negative values.


Source :
https://help.sap.com/docs/SAP_INTEGRATED_BUSINESS_PLANNING/feae3cea3cc549aaa9d9de7d363a83e6/2d11b39a...

But I am not able to envisage your business scenario where you wish to prevent a negative value in a calculated key figure.

Regards

Gaurav

vincentverheyen
Active Participant
0 Kudos

Very interesting, thank you!

Answers (1)

Answers (1)

Irmi_Kuntze
Product and Topic Expert
Product and Topic Expert

Hi Vincent

I am not aware of any possibility.

And bye the way: Why would you want to wait that the error is only thrown AFTER you entered it and only when you try to save or click "simulate"?

For usage in Excel, I personally like the formatting check better.

Except, this is bound to one template only and a user could simply use another one, and it does not work in PWS. Then this would be a reason for a customer influence ticket...