+ Start a Discussion
sdfasdsdfasd 

based on picklist value i need to display Total Currency Field values > 0 using validation rule

i created value "Founded" in Opportunity Stage field. and i created 10 custom  Fields (Datatype= Currency) in Opportunity.

 

1. i Fills  each Currency field value is "0" total 10 currency fields values "0" and i select the Founded value from StageName field. Now i need  display the validation error message. i.e Total Currency Field values  must be > 0.

 

i write code like this

 

AND(ISPICKVAL(StageName,"Founded"),

Building__c +
Land__c +
Tenant_Improvements__c +
Ground_up_construction__c +
Addition_to_building__c +
Renovations__c +
Leasehold_Improvements__c +
Equipment__c +
Furniture_Fixtures__c +
Refinanced_Debt__c +
Other_Expenses__c +
Professional_Fees__c > 0))

 

please help me how can solve this problem...............

 


Navatar_DbSupNavatar_DbSup

Hi,
     You have to simply change the condition in your validation rule.Please follow the below sample code to workaround on your requirement.

 

AND(ISPICKVAL(StageName,"Founded"),
(Building__c +
Land__c +
Tenant_Improvements__c +
Ground_up_construction__c +
Addition_to_building__c +
Renovations__c +
Leasehold_Improvements__c +
Equipment__c +
Furniture_Fixtures__c +
Refinanced_Debt__c +
Other_Expenses__c +
Professional_Fees__c ) < =0))

 Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

SteveMo__cSteveMo__c
AND(
TEXT(StageName) = "Founded",
(Building__c +
Land__c +
Tenant_Improvements__c +
Ground_up_construction__c +
Addition_to_building__c +
Renovations__c +
Leasehold_Improvements__c +
Equipment__c +
Furniture_Fixtures__c +
Refinanced_Debt__c +
Other_Expenses__c +
Professional_Fees__c ) < =0)