Formula

· The user can add a formula while Defining the columns in User Defined Tables.

· User can perform basic arithmetic operations like Addition, Subtraction, Division and Multiplication between any two columns.

· The formula automatically works user update or add a new row.

Step 1: Define User Table

· Here, we add a formula in the pre-defined table. Refer Example

· We add three columns, i.e., Ordering Cost, Holding Cost and Total cost.

· Total Cost is the sum of Ordering Cost and Holding Cost.

· Since the table to already defined, Add new columns in the UDF Table. Select Grid View.

· Enter the Column Name and Data Type. The formula has to be entered in the Total Cost row.

· Follow the syntax for formula, [ColumnName1]+[ColumnName2]

· In this case, [Orderings]+[Holding Cost]

· User must enter Column names in square brackets only. Add and save.

· Other steps like Custom Menu Design and User Authorization remains the same. Refer Example

Step 2: View Result

· Find User Tables in the Menu bar and click on Sample Table Name.

· Click Add icon to add a new row.

· Select Item, Item Description, Data Type, Ordering Cost, Holding Cost and other fields. The total cost will be automatically generated. Add it.

· View the table having Items along with various costs. All the values used for these costs are read-only.