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
XtinaStylesXtinaStyles 

Need Validation Rule to accept only certain % Probabilities

I would like to create a straightforward validation rule that ONLY accepts certain mandated probabilities (0,10,25,50..etc).  I get no error messages but I am not able to save ANY opps when I have this rule:

Probability     <>  0-0.10-.25-.50


It works when I only have 1 number in but once I add multiple probabilities, things go wrong.  How can I get the string correct???

Thanks!


JAW99JAW99
One option - make a probability field restricted to picklist values to only acceptable probabilities.

Formula option - it's a long OR statement restricting probability to 0,10,20,25 and 50% in this example
Code:
NOT
(OR(
Probability = 0.2,
Probability = 0.25,
Probability = 0.5,
Probability = 0.1,
Probability = 0))
it seems to be working for me.
 
(deleted junk)


Message Edited by JAW99 on 12-19-2008 02:10 PM