You need to sign in to do that
Don't have an account?
BobP
Monthly payment formula
I've been trying to figure out a formula for a monthly payment field and my calculations are not coming out correctly.
my formula field formula has a cost(total) field a Number of Months field and a retainer field.
Cost__c - Currency field
Number_of_Months__c - Number field
Retainer_Fee__c - Currency field
So I've tried ((Cost__c / Number_of_Months__c) - Retainer_Fee__c)
Calculation is incorrect though.
Any help with formula would be greatly appreciated
my formula field formula has a cost(total) field a Number of Months field and a retainer field.
Cost__c - Currency field
Number_of_Months__c - Number field
Retainer_Fee__c - Currency field
So I've tried ((Cost__c / Number_of_Months__c) - Retainer_Fee__c)
Calculation is incorrect though.
Any help with formula would be greatly appreciated
Dushyant Sonwar
Didn't understand your problem . Could you please elaborate more on this ?