1. Help Center
2. App Creation
3. Form Elements (BASIC)

# CALCULATE FORM ELEMENT

## Properties of Calculate Form Element

The calculate element field is to store the calculated value to a formula applied in fields.

#### Calculate-Properties • Calculate type: you can see two types of calculations in the drop-down. • Number - Formula applied on number fields.
• String - Formula applied on string fields.
• Create Formula Link: you can click on this link to create a formula in the Create Formula pop-up window.

#### Create Formula for Numbers #### Calculate Minimum, Maximum, and Average values:

Select Number element fields in Calculate Formula to perform Minimum, Average, and Maximum Functions.

#### Maximum Value

• In the Form Builder, add the Calculate element field to the form, and select calculate type as Number. • Click on the Create Formula link. • A Create Formula pop-up window displays on the screen to create a formula. • Select the Max function from the functions list. • Max function adds to the blank space. • Select the Number Elements among which you want to get the maximum number. • Separate the Number Elements in the Formula with a comma (,). • For Example: MAX = MAX (Number1, Number2, Number3).
• Create the Formula and click on the Save button to save the Formula. • The Formula will get saved and will be visible in the properties, as shown below. Note:

• Example: Suppose Number 1 =100, Number 2=299, Number 3=5000.Then the result for MAX Function Value should be 5000.

Ans. MAX = 5000

• If you create Max Function for a Column in the Grid, Then MAX function returns the largest value among the values in the selected column from grid.
• For Example: The MAX Function should return the largest value among the values in the selected column from Grid.   MAX= MAX (Number 1)

Ans. MAX=600

 Number 1 Number 2 200 444 400 212 300 500 600 489 544 939

#### Minimum Value:

• In the Form Builder, add the Calculate form element to the form. • Here, you can apply the calculation formula on grid elements.
• Add form elements to the Grid.
• Add the calculated element to the form to calculate the Minimum value. • In the calculate Properties, select Calculate type as Number.
• Click on the Create Formula. • Create Formula pop-up window is displayed. • Select the Min function from the functions list. • Min function adds to the blank space. • Select the number elements among which you want to get the minimum number.
• For example, we take a grid element to find the minimum number from the grid element's list of values. • If you have more than one element in the Formula, separate the elements with a comma (,).
• The Formula must end with ).
• You can also edit the formula by placing the cursor on the formula. • Create the Formula and click on the Save button to save the Formula. • The Formula is visible in the calculated element properties window. Note:

• Here, in the above Example: Suppose Number1 =100, Number2=299, Number3=5000.Then the result for Min Function Value should be 5000.

Min = 100

• If you create Min Function for a Column in the Grid, Then Min function returns the minimum value among the values in the selected column from grid.
• For Example:     The Min Function should return the largest value among the values in the selected column from Grid.   Min=Min (Number1)

Min=200

 Number1 Number2 200 444 400 212 300 500 600 489 544 939

Note:

You can able to use calculate element inside another calculate element.

• Example: Suppose Number1=100, Number2=299, Number3=400, Number4=5000.
• Average (Calculate Field) = AVG (Number1, Number3) = 250
• Maximum (Calculate Field) = MAX (Number3, Number4) = 5000
• Minimum (Calculate Field) = MIN (Average, Number2) = 100
• Maximum (Calculate Field) = MAX (Minimum, Average) = 250

#### Create Formula for a String • You can combine any two elements and create a formula.

Example: Employee Name + Employee phone number.