![]() |
Page History
Wiki Markup |
---|
{scrollbar:icons=false}
h1. |
Evaluate
...
Mathematical
...
Expressions
...
with
...
the
...
Number-data
...
and
...
Eval-data
...
Macros
...
This
...
page
...
provides
...
the
...
...
...
...
...
...
from
...
the
...
Atlassian
...
site.
...
Table of Contents |
---|
...
|
...
|
...
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.
Code Block |
---|
}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}{code} * |
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
Code Block |
---|
}\%{code} |
which
...
is
...
the
...
correct
...
percentage
...
markup
...
and
...
shows
...
the
...
percent
...
sign.
...
Numerator:
...
Number Data |
---|
...
|
...
|
...
|
...
1 |
Denominator:
...
Number Data |
---|
...
|
...
|
...
|
...
2 |
Result:
...
Evaluate Data |
---|
...
|
...
|
...
|
...
${Numerator}/${Denominator} |
...
Percentage:
...
Evaluate Data |
---|
...
|
...
|
...
|
...
round(${Result} * 100, 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.
Code Block |
---|
}{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} {code} { |
Table Data |
---|
...
| ||||
|
Sum:
Evaluate Data | ||
---|---|---|
| ||
sumtable("Values", "Value") |
...
Average:
...
Evaluate Data |
---|
...
|
...
avgtable("Values", "Value") |
Wiki Markup |
---|
{eval-data}
{scrollbar:icons=false} |