Creating a Formula from the Properties panel
You can set a formula on a form or app page item using the Properties panel. The following instructions describe how to open the Formula editor and select formula options.
About this task
You must set the formula on the form or app page item that stores the result. For example, to add
two numbers, set the formula on the field where you want the result shown.
Note: If
you are creating a formula to assign a string value to a
Time item, the content of the string must be based on
a 24hour clock. If the input value is not in a valid 24hour clock format, the
resulting value will not be correct.
Procedure
 Select the item  the Properties panel displays on the right side of the screen.
 Click the Formula tab in the Properties panel.

Select the function from the list of available options.
The available options are:
 Add – Adds two values together.
 Assign – Assigns a value to the specified item.
 Table Average – Calculates the average column value of a table.
 Concatenate – Concatenates two values together into a single string.
 Power – Raises power of one value to another value.
 Table Max – The maximum column value of a table on the form or app page.
 Multiply – Multiplies two values together.
 Minus – Subtracts one value from another value.
 Table Sum – The sum of a column of a table.
 Table Count – The number of rows in a table.
 Divide – Divide one value by another.
 Table Min – The minimum column value of a table.
After you select a function, input areas and a result area are shown.

Click the Input 1 field.
 Select an item from the list.
 Click Or, Enter a Number. Enter a number in the Value: field, and click OK.

Click the Input 2 field.
 Select an item from the list.
 Click Or, Enter a Number. Enter a number in the Value: field, and click OK.
Note: If your formula contains errors, an error icon is shown. Ensure that a formula is free of errors before applying it to an item.
Results
Save and preview your form to test the formula.