I am interested in creating a formula in a database field that can change if the user changes the input.
Does this have to be done through work flows every time or can you create a field that is calculated off other fields.
For example if a users gets a partial refund/rebate from their supplier then their profit calculation needs to change.
Right now I am calculating Sale Price - (Sale Price x Market Place fees) -(Sale Price x Payment Processor fees) - COGS and then the information is stored a field called Profit.
The user will need the ability to (-) from the COGS when they get a rebate and then also if they ever need to do a partial refund to customer they will need the ability to adjust the Market Place fees and Payment Processor fees automatically by just adjusting the sales price.
I am only a week into learning bubble so if this is an example of a complete newbie question, I apologize.
Thanks!