iMeet® Central phone and live chat support will be unavailable on Monday, July 3rd, and Tuesday, July 4th, in honor of Independence Day.
Please submit all tickets via the portal or email us at support@imeetcentral.com. All tickets will be answered in order of priority on Wednesday, July 5th, at 7am PST.

Database formula field calculations

Field calculations can be performed in a database by adding a formula field. Field calculations allow you to perform addition, subtraction, multiplication, and division operations on any numeric fields in your database. Operations can also be grouped using parentheses (ie. (Field A + Field B) * Field C) The calculated value is then stored and displayed in the formula field.

To add a formula field to a database:

1. In your iMeet® Central database click on Options > Edit > Create New Field

Edit

 

 

 

 

 

 

 

 

 

 

 

 

 

2. Complete the details for the new field and select Formula, Numeric (With Decimals) as the Field Type. An optional Unit of Measure can be entered which will be added to the value within the formula field.

 

 

 

 

 

 

 

 

 

 

 

 

3. Click Create New Field

4. You will be redirected to the Edit Existing fields page. Now, you can create the formula for the new field. Choose from the available numeric database fields and click the Insert button to add the field variable to the formula. Available operators are: + - / * ()

Formula Field
Was this article helpful?       
3 out of 3 found this helpful


Have more questions? Submit a request