Hi @Nick_O_Shea - this is definitely possible, but it sounds like you’ll want some further structure outside of just this one formula, in order to make a system that is going to work smoothly for you.
For example, you probably do not want to hardcode your prices into this formula. That would make them difficult and obscure to change if you ever need to change prices in the future. If you prices are listed in another table, then you can change them in the future easily by just interacting with that table. But you also don’t want to just change values that are used in the formula directly, because that will change all of your historical records as well. So what you want is a way to create Pricing Schedules, where you can implement a new pricing schedule that affects prices on all future orders, but doesn’t mutate the prices of past orders.
Lastly, I presume you’ll already have a structure for Orders built, but do you need to account for “Line Items” within an order? What if you want to make new items available on the menu? Do you have a system in place for that so that it’s not a disruptive ordeal in the future?
Hopefully that all makes sense - what I’m saying is, do you really need just this one formula, or do you need a solid and flexible system in place for managing catering orders? I’m happy to help with that as well. Just give us an idea of where you are at in the development of your system.
