Formula for Amortization
Hello! I do hope I'm posting this in the correct spot after the Community UI change. I've been wracking my brain trying to come up with a formula that accomplishes what I need for my app. We buy so...
Forum Discussion
Most definitely... thanks for calling that out. I just created them as formula - numeric, displaying as currency. I'll tweak as needed which they will since I'm still a novice
------------------------------
Victoria Law
------------------------------
------------------------------
Victoria Law
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legend... and then just to keep it interesting, the order date can be any day of the month, I suppose, do do we need to deal with partial months?? Or can we keep it in monthly buckets like a contract with an order date of Jan 15th would get say 1/12th into January if it was a 1 yr contract. Partial months make it more complicated.
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------
- Good question, whole month buckets. Thankfully. Maybe in the future I'll be back asking about partial months but for now whole months are enough
------------------------------
Victoria Law
------------------------------