Highlighted
New Contributor

Limit on Input values

I want a certain limit on the total of my input data:

  • List of 5 products
  • Input Module in which a percentage can be inputted per product
  • The total of the percentages can't be more than 100%

Is there a way to show a certain error message once the input results in a percentage of more than 100%?

 

Thanks! 

Faas

 

2 REPLIES
Occasional Contributor

Re: Limit on Input values

Hi Faas,

 

Photo1.png

Check the All products % total>1 or not..

 

Expert

Re: Limit on Input values

Just extending the above, if you used a "1" instead of TRUE, you could use conditional formatting to highlight the products

Further information can be found here:

https://help.anaplan.com/anapedia/Content/Modeling/Working_with_Data/Conditional_Formatting.html

 

Hope this helps

David