Mathematical Calculation Tracker Field

A basic tracker field that calculates its value from the other fields in the tracker item. The calculation uses the same syntax as Calculations. It is very useful for Grouped Data

Available functions are limited to the basic ones not needing the object-type and object-id.

The other fields are available as variables based on their permanent name.

Sample
Copy to clipboard
(mul priority severity)

Samples of formula you can use in tracker fields

Dates

Calculate age from date of birth
Copy to clipboard
(if childrenBirthDate (round (div (sub (date) childrenBirthDate) 31536000 ) 1))


The syntax is explained in more details: Advanced Rating

Math fields can mirror output behavior from another field.

Useful for currency calculations, itemlink or other field calculations where the output must be similar to the output of those fields
New in Tiki22 and backported for 21.2

Test Your Calculations with the fitness plugin

The sample above is rather simple, but calculations can quickly become more complex. Make sure it produces the results you expect by creating a test suite using PluginFitnesse. It can also serve as a documentation.

Examples
Copy to clipboard
{FITNESS()} {TRACKERMATH(trackerId=42)} priority|severity|importance? 1|1|1 2|3|6 10|10|100 {TRACKERMATH} {FITNESS}


In some cases, some of the data depends of the search index being up to date. So this can be a good idea: Cron Job to Rebuild Search Index


Related:

alias