NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{scrollbar:icons=false}

Page info
title
title

Table of Contents
minLevel2

The evaluate data macro allows evaluation of mathematical expressions using data in number data macros.

More information on the evaluate data macro

Multiexcerpt include
nopaneltrue
MultiExcerptNameExitDisclaimer
PageWithExcerptwikicontent:Exit Disclaimer to Include

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}

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
\%

which is the correct percentage markup and shows the percent sign.

The number data macro establishes the numerator. Enter a new value in the Edit Contents view.

Number Data
nameNumerator
decimaltrue
1


The number data macro establishes the denominator. Enter a new value in the Edit Contents view.

Number Data
nameDenominator
decimaltrue
2

The evaluate data macro displays the result:

Evaluate Data
nameResult
format#0.0
${Numerator}/${Denominator}


The evaluate data macro displays the percentage:

Evaluate Data
namePercentage
format##0
round(${Result} * 100, 0)

Evaluating Data in Tables

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}

The table data macro contains a table with text data for the name and number data for the value. In the Edit Contents view select the plus sign to add a row and enter values for each row.

Table Data
nameValues
orderasc

Name

Value

wikiNameINLINE ValueINLINE

The evaluate data macro calculates the sum of the values in the table:

Evaluate Data
nameSum
sumtable("Values", "Value")


The evaluate data macro calculates the average of the values in the table:

Evaluate Data
nameAverage
avgtable("Values", "Value")
Wiki Markup
{scrollbar:icons=false}