I need to create a complex formula, which sums fields based on picklist values.
My fields are as follows:
Picklist1__c : Val1, Val2 Picklist2__c : Val1, Val2 Picklist3__c : Val1, Val2 Number1__c Number2__c Number3__c Total_Amount__c
The first three fields are my picklist fields, the next fields hold a number and
Total_Amount__c is the formula field that I need to create. The formula needs to add all numbers, where the corresponding picklist value has Val1 selected. Example:
Picklist1__c: Val1 Number1__c: 100 Picklist2__c: Val2 Number2__c: 50 Picklist3__c: Val3 Number3__c: 30
The result for
Total_Amount__c should be:
Is there an easy way to express this in a formula?