I need help with mathematical formulas
I am super new to QB so please bare with me... I created a table of sales reps and on that table has a gross amount listed. I need to create a formula for this gross amount to be a certain percentag...
Forum Discussion
You'll need to create a new field. Go to Settings>Fields>Add New and select type Formula - Numeric. Then all you need to do is write out the calculation you want, enclosing field names in brackets.
For example, if you have a field called Gross Amount and you need 10% of that, the formula would be:
[Gross Amount] * .1
For example, if you have a field called Gross Amount and you need 10% of that, the formula would be:
[Gross Amount] * .1