How to set up a Calculation Field in the Legacy Builder

Have more questions? Submit a request

GoCanvas has the ability to calculate things for you, helping to eliminate mathematical errors and save you time.

Calculating Number Fields

There are endless possibilities and reasons for performing calculations in a form.

A common use of this field type is for calculating billable items such as time and materials. We'll use this example to show you how to set up successful calculations in a form.

First, we must determine the Total.

  1. Launch the Legacy Builder.
  2. Drag a Number field from the field library into your form and label it "Quantity." In the Field Settings, change the Style to Currency.
  3. Drag another Number field into your form (or copy the previous field) and label it "Unit Price." In the Field Settings, change the Style to Currency.
  4. Drag a Calculation field into your form and label it "Total."
  5. Under the Calculation section, select Create Calculation.
  6. Select Quantity for Operator 1.
  7. Select the Multiplication icon. 
  8. Select Unit Price for Operator 2.LB_Calculation_Unit Price x Quantity.png
  9. Toggle to Format to confirm it is set to Currency and select Done to close the modal.

The Total field will automatically multiply the Quantity and Unit Price fields for you. 

You can add as many fields as necessary to achieve your end result. Simply select New Operator to add more fields and operators to the calculation. 

Please Note

Calculation fields do not follow PEMDAS so in order to get the correct answer, be sure to build you calculations following these rules.

Calculating Fields with Constants

If you would like to calculate something using a constant (static) number, an easy way is to add a constant variable by selecting the Add Constant button.   

For example, if you apply the same tax rate of 6% to all of your billable items, you can Add a Constant of 0.06 and multiply it with your Total field. 

  1. Drag a Calculation field from the field library into your form and label it "Tax."
  2. Under the Calculation section, select Create Calculation.
  3. Select Total for Operator 1.
  4. Delete Operator 2 with the x in the right corner of the operator box, then add a New Operator.LB_Calculation_New Operator.png
  5. Select Constant, then enter the decimal form of your percentage (in this case 6% = 0.06).LB_Calculation_Constant.png
  6. Select the Multiplication icon.
  7. Toggle to Format to confirm it is set to Currency and select Done to close the modal.

You can use multiple fields and constants in a single calculation field.

To get the grand total of your item total plus tax, you'll simply set up one more calculation field adding those two fields together.

Articles in this section

Was this article helpful?
0 out of 2 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.