Calculated Fields

A calculated field allows you to input a formula into the field. Its value is the result of a calculation rather than a value that's input by a user.  TrackVia provides 8 different types of calculated fields, and the field type you choose determines the display format of the field's value.

• currency
• date
• email
• number
• percentage
• text
• TrackVia user
• URL

For example, suppose your formula produces a result of 0.3 in a certain record.

• In a calculated number field, that result will show up as 0.3.
• In a calculated percentage field, it will show up as 30%.
• In a calculated currency field, it will be displayed as $0.30.
• In a calculated date field, it will be displayed as (none), because TrackVia doesn't know how to interpret 0.3 as a date. In a calculated text field, it will show up as 0.3, but it will sort alphabetically instead of numerically (e.g. 12 comes before 2), and have filtering options in views that are similar to other text fields instead of numeric fields (e.g. "contains" instead of "is greater than"). 

In summary, a formula's calculation works the same way for any type of calculated field, but how the formula result is interpreted, and how the field is displayed, sorted, searched, and filtered, depends on the specific type of calculated field you choose.