IF(ISPICKVAL( Product__c , "Hosting Only"), Annual_Hosting_Amount__c ,
IF(AND(ISPICKVAL( Product__c , "EMS"),(ISPICKVAL(Billing__c , "Perpetual"), (ISPICKVAL(License_Delivery__c, "Hosted” ),((Annual_Hosting_Amount__c) + (Software_Discount_Total__c)) ,
IF(ISPICKVAL( Billing__c , "Subscription"), Software_Discount_Total__c,
IF(ISPICKVAL( Billing__c , "Migration"), Annual_Hosting_Amount__c ,
IF(ISPICKVAL( Billing__c , "Perpetual"), (Software_Discount_Total__c)*(1.66/3),Null)))))))
Thanks,
Eric
답변 5개