Custom Field Type: Special – Calculated Value

General Description

Executes an expression to calculate a value and store the result. Additional information can be found in the SmartSimple wiki.

Field Options

• Allow Empty: N/A
• Default Text: N/A
• Options: Expression
• Track Changes: Yes
• Store To Value: N/A

Special Options for Field

Expression – defines the expression to be executed.

All values are treated as strings. For arithmetic operations, PARSEINT and PARSEFLOAT functions are used to convert the string value to a numeric value.

Example summing the values using five custom fields:

ParseFloat([Total Monthly Cost]) + ParseFloat([Total Cost Ex]) + ParseFloat([Hardware Rental]) + ParseFloat([Email]) + ParseFloat([Other])

Field Validation

• Type: N/A
• JavaScript Validation: N/A
• Message: N/A
• HTML Tag: N/A

Field Formatting Options

• Height: N/A Measure: Default:
• Width: N/A Measure: Default:
• Number Format: Yes
• Style: Yes
• Tool Tip: Yes

Notes

You can use arithmetic, string, comparison operators and functions within the calculated custom field.

• References to other fields are always enclosed in square brackets: [variable1]
• The calculations are performed when you click the Save button and save the page.

Important Notes on Calculation Order

• Calculated field formulas are executed in the same order that the calculated fields are displayed on the page.
• You must not place fields that perform summary calculations based on other calculated fields ABOVE the subordinate calculations.
• If the fields are ordered in this manner, saving the page will not update the summary calculation, as summary formula will be executed BEFORE the subordinate calculations are performed.