Skip to main content
Topics#Sales And MarketingFrage von Amin Ahcene
Amin Ahcene fragte in #Sales And Marketing
26. Juni 2019, 16:25

Formula with conditions

Hello everyone , here is what i am trying to achieve but i have an error of syntax

 

AND (

 

IF

 

( Agencie2019_C  !=  AgencieCurrent_C ,

 

TotalAmountAuto__c * 

 

CASE( Agencie2019_C ,

 

"Agencie A",1,

 

"Agencie B",0.70,

 

"Agencie C",0.70,

 

0,

 

),

 

IF(Agencie2019_C  =  AgencieCurrent_C ,

 

TotalAmountAuto__c * 

 

CASE( AgencieCurrent_C ,

 

"Agencie A",1,

 

"Agencie B",0.70,

 

"Agencie C",0.70,

 

0,

 

)

 

 
1 Antwort
  1. Lalit Arora (Melonleaf Consulting)
    26. Juni 2019, 16:41
    i believe this is the duplicate question can you please close this to keep the community clean
Antwort schreiben...
0/9000