ContributionsMost RecentMost LikesSolutionsRe: Formula for AmortizationGood 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 ------------------------------ Re: Formula for AmortizationMost 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 ------------------------------ Formula for AmortizationHello! 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 software licenses, and we record spend for each yeardepending on how many months are in the contract period. Example of what I'm trying to accomplish (using numbers I'm making up): We buy a QuickBase enterprise license for $12,000 that's good for 1 year (12 months) on September 1st. The cost works out to $1,000/month. This means $4,000 needs to show in a field for 2019, and the remaining $8,000 will show in a field for 2020. (and so on if needed) I have thesefields already set up that I'm thinking are pieces needed in this equation. Order Total Order Date Contract Period in Months I started out thinking I need a formula that will divide the Order Total by Contract Period in Months to work out the monthly cost, and compare it against the order date to know how many months are left in 2019 to display what I need but I have no idea how to go about writing it. I'm hoping there is a formula guru here that can take a look and steer me in the right direction. ------------------------------ Victoria Law ------------------------------ Re: Formula - Rich Text code displaying on dynamic filterThis worked a treat and seems so simple now. Thanks for your help!Formula - Rich Text code displaying on dynamic filterHello! I'm a beginner to QB. I've searched high and low in the community posts for a similar question and haven't come across any. I wrote a rich text formula to evaluate if a date is before or after today's date and mark the status "Active" and green or "Inactive" and gray. It works beautifully except the code to change the colors is being displayed in the dynamic filter. Ideally it would only display "Active" or "Inactive". If anyone can review my formula and help me fix it, it would be appreciated! If([Term End] > Today(),"<div style=\"color:green;\">Active</div>", "<div style=\"color:gray;\">Inactive</div>")