You need to sign in to do that
Don't have an account?
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...............
Hi,
You have to simply change the condition in your validation rule.Please follow the below sample code to workaround on your requirement.
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.