This page provides the information on the eval-data macro from the Atlassian site.
The eval-data macro allows evaluation of mathematical expressions using data in number-data macros.
Basic Mathematics
The following calculates the value of a fraction, initially 1/2.
Numerator: {number-data:Numerator|decimal=true}1{number-data} Denominator: {number-data:Denominator|decimal=true}2{number-data} Result: {eval-data:Result|format=#0.0}${Numerator}/${Denominator}{eval-data} Percentage: {eval-data:Percentage|format=##0\%}round(${Result} * 100, 0){eval-data}
Observation: The Basic Mathematics example, with the formatting by the java.text.DecimalFormat rules shown in the example from Atlassian, yields the result 5000%. To obtain 50 it was necessary to remove
\%
which is the correct percentage markup and shows the percent sign.
Numerator:
Denominator:
Result:
Percentage: 0
Evaluating Data in Tables
In the Editview, the text-data and number-data macros present a plus sign with the table. Clicking the plus sign opens the table to accept names of variables and values for them. The eval-data macros calculate the sum and the average.
An example follows.
{table-data:Values} || Name || Value || | {text-data:Name}{text-data} | {number-data:Value}{number-data} | {table-data} Sum: {eval-data:Sum}sumtable("Values", "Value"){eval-data} Average: {eval-data:Average}avgtable("Values", "Value"){eval-data}
Name |
Value |
---|
Sum: 0
Average: 0