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
Chris SChris S 

Validation Rule on Opportunity Amount

I am new to validation rules.. trying to create a rule that certain opportuntiy stages can't have blank or zeros in the amount field. The below rule works if the field is Blank.. but if the field has $0.00.. it does not..I have tried several things.. I got the rule to give warning on $0.00.. but then yoo could not change the field. 

AND (
     ISPICKVAL( StageName, "Negotiate Revisions"),
     ISBLANK (Amount))

Thanks!

 
Fabio PalladinoFabio Palladino
Hi Chris,
You can try to add a simple OR statement inside your rule:

AND(
     ISPICKVAL( StageName , 'Negotiate Revisions​') ,
     OR(
          ISNULL( Amount ),
          Amount  = 0
          )
)

let me know if it works

Regards

 
Chris SChris S
Thank you for your reply.... but this did not work. I created two separate rules, that are working..one with ISBLANK (Amount) the other:

AND (
     ISPICKVAL( StageName, "Negotiate Revisions"),
     (Amount=0)

Seems when they are in one rule they cancel each ohter..

Thanks!
 
Fabio PalladinoFabio Palladino
Hi Chris,
It's strange because it works for me, I have tested it in my dev environment.
But the way of two validation is the correct way if it works for you !!!

Regards
Fabio