This template calculates the percent change between two real number values and displays the result in a sortable format.

The syntax for this template is as follows.

{{change|1st_number|2nd_number|dec=rounding|pre=prefix|suf=suffix|sort=on/off|italics=on/off|bold=on/off|invert=on/off|disp=row/out|rowspan=rowspan|align=alignment|bgcolour=background colour}}

Examples

edit

The following sortable tables illustrate the use of this template.

Wiki markup Tables
{|class="wikitable sortable"
!Region
!first
!second
!change
|-
|Big Meadow
|{{change|1830000|1900679.75}}
|-
|Little Meadow
|{{change|400000|500000}}
|-
|Mount Acme
|{{change|2450000|2205678.37}}
|-
|Acmevale North
|{{change|1250000|1000000|rowspan=2}}
|-
|Acmevale South
|-
|Homeport
|{{change|5120000|5589462.60|dec=0}}
|-
|Longwood
|{{change|930000|930027.92|dec=3}}
|-
|Meadowbrook
|{{change|2450000|2450000.00|pre=$}}
|-
|Johnstown
|{{change|3400000|3902340.05|suf= kg}}
|-
|Lakewood
|{{change|2250000|2236005.56|align=center}}
|- style="background-color:lightblue"
| Fox Hollow
|{{change|1180000|1190345.32|bgcolour=lightblue}}
|-
|Riverton
|{{change|10550000|11236005.55|bold=on}}
|-
|Timber Creek
|{{change|1360000|1310948.30|italics=on}}
|-
|Terminated
|{{change|1500|0.00|bold=on|italics=on}}
|-
|Upstart
|{{change|0|26250.50|align=left}}
|-
|}
Without extra code
Region first second change
Big Meadow 1,830,000 1,900,679.75 +3.86%
Little Meadow 400,000 500,000 +25.00%
Mount Acme 2,450,000 2,205,678.37 −9.97%
Acmevale North 1,250,000 1,000,000 −20.00%
Acmevale South
Homeport 5,120,000 5,589,462.6 +9%
Longwood 930,000 930,027.92 +0.003%
Meadowbrook $2,450,000 $2,450,000 0.00%
Johnstown 3,400,000 kg 3,902,340.05 kg +14.77%
Lakewood 2,250,000 2,236,005.56 −0.62%
Fox Hollow 1,180,000 1,190,345.32 +0.88%
Riverton 10,550,000 11,236,005.55 +6.50%
Timber Creek 1,360,000 1,310,948.3 −3.61%
Terminated 1,500 0 −100.00%
Upstart 0 26,250.5 NA
With |disp=out
Region change
Big Meadow +3.86%
Little Meadow +25.00%
Mount Acme −9.97%
Acmevale North −20.00%
Acmevale South
Homeport +9%
Longwood +0.003%
Meadowbrook 0.00%
Johnstown +14.77%
Lakewood −0.62%
Fox Hollow +0.88%
Riverton +6.50%
Timber Creek −3.61%
Terminated −100.00%
Upstart NA
With |invert=on
Region first second change
Big Meadow 1,830,000 1,900,679.75 −3.72%
Little Meadow 400,000 500,000 −20.00%
Mount Acme 2,450,000 2,205,678.37 +11.08%
Acmevale North 1,250,000 1,000,000 +25.00%
Acmevale South
Homeport 5,120,000 5,589,462.6 −8%
Longwood 930,000 930,027.92 −0.003%
Meadowbrook $2,450,000 $2,450,000 0.00%
Johnstown 3,400,000 kg 3,902,340.05 kg −12.87%
Lakewood 2,250,000 2,236,005.56 +0.63%
Fox Hollow 1,180,000 1,190,345.32 −0.87%
Riverton 10,550,000 11,236,005.55 −6.11%
Timber Creek 1,360,000 1,310,948.3 +3.74%
Terminated 1,500 0 NA
Upstart 0 26,250.5 −100.00%
With |invert=on and |disp=out
Region change
Big Meadow −3.72%
Little Meadow −20.00%
Mount Acme +11.08%
Acmevale North +25.00%
Acmevale South
Homeport −8%
Longwood −0.003%
Meadowbrook 0.00%
Johnstown −12.87%
Lakewood +0.63%
Fox Hollow −0.87%
Riverton −6.11%
Timber Creek +3.74%
Terminated NA
Upstart −100.00%

This template uses Module:Math and Template:ntsh, and produces a sort compatible with Template:nts and Template:ntsh.

TemplateData

edit
This is the TemplateData for this template used by TemplateWizard, VisualEditor and other tools. See a monthly parameter usage report for Template:Change in articles based on its TemplateData.

TemplateData for Change

No description.

Template parameters

ParameterDescriptionTypeStatus
1st_number1

The first number displayed representing the base value

Numberrequired
2nd_number2

The second number displayed representing the object value

Numberoptional
decdec

Number of decimal places to round the percentage change to

Numberoptional
prepre

Prefix to the first and second numbers

Stringoptional
pre1pre1

Prefix to the first number

Stringoptional
pre2pre2

Prefix to the second number

Stringoptional
sufsuf

Suffix to the first and second numbers

Stringoptional
suf1suf1

Suffix to the first number

Stringoptional
suf2suf2

Suffix to the second number

Stringoptional
sortsort

Adds or removes the {{nts}}-compatible sort key from the first two cells. The default is only to add this if a prefix or suffix is used (i.e. only if needed).

Suggested values
on off
Unknownoptional
italicsitalics

Makes the output italic

Suggested values
on off
Default
off
Unknownoptional
boldbold

Makes the output bold

Suggested values
on off
Default
off
Unknownoptional
invertinvert

Switches the base and object values in the calculation of percentage change

Suggested values
on off
Default
off
Unknownoptional
alignalign

Adjusts the alignment of text in cells

Suggested values
center left right
Default
right
Unknownoptional
rowspanrowspan

Adjusts the row span of cells

Default
1
Numberoptional
bgcolourbgcolour

Adjusts the background colour of cells, or by default, inherits from the table

Default
inherit
Example
lightblue
Unknownoptional
dispdisp

This controls what is outputted. "|dist=out" produces the percentage change only (and thus the "|align=", "|rowspan=" and "|=bgcolour" parameters do not work with "|disp=out"). "|disp=row" produces three cells in a table row.

Suggested values
out row
Default
row
Unknownoptional

Tracking

edit

Invalid input is tracked using WhatLinksHere for {{change/error}}.

See also

edit