function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
kjunkjun 

trying to create a formula that will not allow a user to enter a value of 20% or lower

I've created this VR that will prevent a user from entering a value over 100. Is it possible to add to the syntax that would also not allow a user to enter a value of less than 20%? 
  
Percent_Value__c  > 1

 
Best Answer chosen by kjun
Maharajan CMaharajan C
Hi,

Try the below one it will work:

Percent_Value__c  < 0.2

=======================


If you want to restrict the percentage only between 20% and 100% then use the below one:

OR(
Percent_Value__c  > 1.0,
Percent_Value__c  < 0.2
)



Thanks,
Maharajan.C