I have a select field with expense categories (rent, gas etc) and I want to create an equation where I can specify how to do calculations for each select field.
In other databases I would do something like:
if Expense = 1 then Total x 0.3333
if Expense = 2 then Total / 3
...and so on. Is something similar possible with Knack?