History: Computed Tracker Field

             {BOX()} 
This is deprecated and has some security issues. Please use ((Mathematical Calculation Tracker Field)) instead.

{BOX}

# Computed Tracker Field


This field type allows you to compute a field function of other field of the item.

You use # for indicating fieldIds and +,\*,/,- and parenthesis for operations.

For example, if you have a field with an Id of **3** which has a numeric quantity, and a field with an Id of **4** which has an item price, to multiply quantity and price: **\#3\*#4**

A file containing a little script to sync a computed field is attached to this page. This is useful when you add a new computed field on existing items for instance.

Since Tiki 15.0 (or 14.2, 12.5), you can indicate:

- Decimal Places: 
     Amount of decimals to preserve before rounding.
- Decimal separator when displaying data: 
     Single character. Use c for comma, d for dot or s for space. The valid decimal separator when inserting numbers may depend on site language and web browser. See documentation for more details.
- Thousand separator when displaying data 
     Single character, Use c for comma, d for dot or s for space. When inserting data no thousands separator is needed.

## Known limitations

1. While it can do calculations between dates, it can't give a negative value for days. So if you are measuring how many days ahead or late you are according to schedule, you can't have -6 days. Solution: 
    - Use ((Mathematical Calculation Tracker Field)) instead. Syntax: sub
2. There was no way to round of values in Tiki versions prior to Tiki 15.0 (or 14.2, 12.5). So you could end up with a value like 5.71228448276 . solution: 
    - Upgrade to Tiki 15.0 (or 14.2, 12.5) at least, and use the provided extra option to indicate the number of decimal points that you need.
    - Use ((Mathematical Calculation Tracker Field)) instead. Syntax: round