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
Sea_AdminSea_Admin 

Amount must be greater than 0

Hi All-

I need to enter a validation rule that requires the amount to be greater then 0 when the stage is Closed/Lost and on a certain record type.  I have tried a variety of things and am getting nowhere.   Has anyone done something simliar?

Thanks!
JakesterJakester
Should be pretty easy - something like this?

Code:
and(
     ispickval(stage,"Closed/Lost")
    ,or(
         recordtypeid = "youridhere"
        ,recordtypeid = "yournextidhere"
     )
     ,amount = 0
)

 
Sea_AdminSea_Admin
Thank you so much!