Today i am trying to create a formula where i calculate a revenue.
And i want to put a condition where :
When Picklist Agency : Agency A has been selected it takes away 10% of the revenue Marketing.
Here is my formula :
Ad_gross_Revenue_2019__c +
CASE( PicklistAgency__c,"Agency A",(Revenue_2019__c - ((Revenue_2019__c*10)/100)),Revenue_2019__c)
+ Print_Revenue_2019_Gross__c +
App_Revenue_2019_Gross__c
it doesn't seem to work, so I will be glad to have some inputs.
Best
2 réponses
Hi Amin,
Let's try and simplify it:
(Ad_gross_Revenue_2019__c *
CASE( PicklistAgency__c,"Agency A", 0.9,
1))
+ Print_Revenue_2019_Gross__c +
App_Revenue_2019_Gross__c
Now, I must warn you that this approach will not be good in the long term. You'll add more and more agencies until you hit the maximum formula length. I strongly recommend that you convert it to a related object (possibly account) with a lookup field, and have the revenue as a field on that related object.
