Basically we have a starting maintenance cost which increases on the anniversary of the 'start date' if the 'payment frequency' = either monthly, quarterly,semi-annual or annual (we dont want it to increase if the payment frequence = the other options i.e. monthly fixed, quarterly fixed, semi-annual fixed or annual fixed). We have the 'start date' as a seperate field. The value should update every 12 months where either monthly, quarterly, semi-annual or annual is shown in 'payment frequency' field from the chosen pick list.
On 1st annual anniversary I need to multiple "starting maintenance" contract by 1.05
On 2nd annual annivasary i need to multiple "starting maintenance" contract by 1.1025
On 3rd annual annivasary i need to multiple "starting maintenance" contract by 1.157625
On 4th annual annivasary i need to multiple "starting maintenance" contract by 1.21550625
On 5th annual annivasary i need to multiple "starting maintenance" contract by 1.276281563
any ideas?
8 个回答
It's because I'm an idiot...
Change greater or equal to lower or equal symbols
Starting_Maintenance_Cost__c*
IF(CASE( Payment_Frequency__c, 'monthly',1,'quarterly', 1, 'semi-annual', 1, 'annual',1,0)=1,
IF(ADDMONTHS(Start_Date__c, 60)<=TODAY(), 1.276281563,
IF(ADDMONTHS(Start_Date__c, 48)<=TODAY(), 1.21550625,
IF(ADDMONTHS(Start_Date__c,36)<=TODAY(), 1.157625,
IF(ADDMONTHS(Start_Date__c, 24)<=TODAY(), 1.1025,
IF(ADDMONTHS(Start_Date__c,12)<=TODAY(), 1.05, 1))))),1)
I tested it in my org, and it worked
