Formula custom field with Advanced Editor

Hi @Scott_Burkinshaw , sure you can! For the formulas, simply replace your percentages with a decimal, so for example, 55% would be 0.55, or +55% would be 1.55

For example, if you want to get say 15% of one of your number field’s value (eg. your ‘Cost’ field), you would input in the formula advanced editor as such: [Cost field]*0.15 to give you the value of that 15%.

If you want the total value, i.e. your cost field + 15%, then you would input in the formula advanced editor as such: [Cost field]*1.15

You can also have a look at my post below, especially numbers 9-12 where I show examples applying tax or discounts:

1 Like