Limit on Input values

Faas

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

 

VIGNESH.M

Hi Faas,

 

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

 

DavidSmith

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