Skip to main content
Topics#Data ManagementPergunta de Amin Ahcene
Amin Ahcene perguntou em #Data Management
26 de jun. de 2019, 16:23

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( Marketer__c ,

 

"Agencie A",1,

 

"Agencie B",0.70,

 

"Agencie C",0.70,

 

0,

 

)

 

 
2 respostas
  1. Payal Mittal (Aethereus)
    26 de jun. de 2019, 17:23
    Hi Amin,

     

    Just formatted your formula.

     

    But to make it perfectly working, business requirement is important to know.

     

    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( Marketer__c ,

     

            "Agencie A",1,

     

            "Agencie B",0.70,

     

            "Agencie C",0.70,

     

            0,

     

            )

     

        )

     

    )
Escrever uma resposta...
0/9000