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
So, before i reply are you sure that you want hard coded fields for the years. You will make yours elf crazy .... would a better way to go be to have a fields for the
[Last Year amortization]
[Current Year Amortization]
[Next Year Amortization]
That way your reports would all be stable and you would not need to keep adding new fields every year.
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------
[Last Year amortization]
[Current Year Amortization]
[Next Year Amortization]
That way your reports would all be stable and you would not need to keep adding new fields every year.
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------
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
------------------------------
- ... 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
------------------------------- 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
------------------------------
