TotalAmountAuto__c *
CASE( use Agencie_2018__c if different from Agencie_current_C,
"agencieA",1,
"agencieB",0.70,
"agencieC",0.70,
0
)
Thank in advance for the input :)
1 个回答
Hi Amin, Your formula would be:
TotalAmountAuto__c *
CASE(Agencie_2018__c,
"agencieA",1,
"agencieB",0.70,
"agencieC",0.70,
0
)
Let's think about it: If Agencie_2018__c is the same as Agencie_current__c, then you want to use the value in Agencie_2018__c (which is the same).
If they aren't the same, you still want to use the value in Agencie_2018__c.
Unless I'm missing something?
