I need to run a formula which basde on the selection from a picklist e.g. Monthly, Quarterly, semi-annual or annually another field (annual admin fee) is divided to give relevant value.
The below is what i have but it isnt working, any suggests?
(IF(Payment_Frequency__c = Monthly, Annual_Admin_Fee__c/12, IF(Payment_Frequency__c = Quarterly, Annual_Admin_Fee__c/4, IF(Payment_Frequency__c = Semi-annual, Annual_Admin_Fee__c/2, IF(Payment_Frequency__c = Annual, Annual_Admin_Fee__c)))))
1 件の回答
Hello Brooke, Give this a try:
Annual_Admin_Fee__c/
CASE(Payment_Frequency__c,
"Monthly",12,
"Quarterly",4,
"Semi-annual",2,
1)
