Skip to main content
I'm trying to create a custom field that adjusts the opportunity amount based on the length of a customer' s finance term. The finance terms are chosen from a picklist (Finance_Term__c)

 

The parameters are:

 

12 months = Amount - 12%

 

24 months = Amount - 15%

 

36 months = Amount - 19%

 

48 months = Amount - 21%

 

Any help would be much appreciated!
5 respuestas
  1. 2 dic 2013, 2:19 a.m.
    IF( ISPICKVAL( Finance_Term__c, "12") ,Amount- Amount*0.88 ,

     

    IF( ISPICKVAL( Finance_Term__c , "24"),Amount-Amount*0.85,

     

    IF(ISPICKVAL( Finance_Term__c , "36"),Amount-Amount*0.81,

     

    IF( ISPICKVAL( Finance_Term__c , "48"),Amount-Amount*0.79,0))))