Data validation in IBP, allow negative % up to -100% minimum

[former_member862651]

sap2.pngHello,

I would like one of my key figures to have the following data validation:

allowed to enter anything from -100% to +1000%.

Below is the condition I have entered (and yes I have selected data validation for that member). However it now blocks me from entering any negative value (eg. -20%)

Does someone know what exactly I should enter in order to be able to enter -% up to -100%?

Thank you!

[moshenaveh]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[former_member862651]

Hi Zsombor,

Thanks for your help!

I have taken your suggestion and changed my data validation settings to the ones below:

Decimals between -1 and 1

However, when I try to enter -20%, I encounter this problem when simualting:

image.png

Do you think it could be because my figure is formatted as % and not absolute values?

Thanks!

Eva

[guglanigaurav1987]

Hi Eva,

The key figure that you are entering negative values into has been 'Enabled for Fixing' in the configuration. Such Key figure configurations don't allow Negative values.
Thus, if your requirement is to have Negative Values in the KF, please uncheck Flag 'Fixing Enabled' in the Key figure Configuration in the Planning Area.

Regards
Gaurav

[szezso]

Hello Eva,

For this, you'll need to allow decimals as well to be used. Furthermore, if you'd like to enter values from -100% to +100%, you should set the minimum to -1 and the maximum to +1 as the Data Validation setting can't differentiate between percentage and whole numbers.
Hope this helps!

Regards,
Zsombor

[former_member862651]

Hi Zsombor,

Thanks for your help!

I have taken your suggestion and changed my data validation settings to the ones below:

Decimals between -1 and 1

However, when I try to enter -20%, I encounter this problem when simualting:

Thanks!

Eva