
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 Antworten
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))))