on 2023 Oct 05 4:21 PM
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.
Request clarification before answering.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
4 | |
3 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.