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 No.|2nd No.|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}}

parameter function
1 1st No. is the first number displayed representing the base value.
2 2nd No. is the second number displayed representing the object value.
dec This is the number of decimal places to round the percentage change to.
pre This adds a prefix to the first and second numbers.
pre1 This adds a prefix to the first number.
pre2 This adds a prefix to the second number.
suf This adds a suffix to the first and second numbers.
suf1 This adds a suffix to the first number.
suf2 This adds a suffix to the second number.
sort This 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).
italics This can either have the value of on or off. italics=on makes the output italic. The default is italics=off.
bold This can either have the value of on or off. bolds=on makes the output bold. The default is bold=off.
invert This can either have the value of on or off. invert=on switches the base and object values in the calculation of percentage change. The default is invert=off.
align This adjusts the alignment of text in cells. align=center and align=left aligns the text to the centre and left respectively. The default is align=right.
rowspan This adjust the row span of cells. The default is rowspan=1.
bgcolour This adjusts the background colour of cells. The default is bgcolour=inherit (inherits this value from the table).
disp This controls what is output. disp=out produces the percentage change only (and thus align, rowspan and bgcolour do not work with disp=out). The default is disp=row which produces three cells in a table row.

Examples

uah

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 190.067.975 +10.286,23%
Little Meadow 400.000 500.000 +25,00%
Mount Acme 2.450.000 220.567.837 +8.902,77%
Acmevale North 1.250.000 1.000.000 −20,00%
Acmevale South
Homeport 5.120.000 558.946.260 +10.817%
Longwood 930.000 93.002.792 +9.900,300%
Meadowbrook $2.450.000 $245.000.000 +9.900,00%
Johnstown 3.400.000 kg 390.234.005 kg +11.377,47%
Lakewood 2.250.000 223.600.556 +9.837,80%
Fox Hollow 1.180.000 119.034.532 +9.987,67%
Riverton 10.550.000 1.123.600.555 +10.550,24%
Timber Creek 1.360.000 131.094.830 +9.539,33%
Terminated 1.500 0 −100,00%
Upstart 0 2.625.050 NA
With |disp=out
Region change
Big Meadow +10.286,23%
Little Meadow +25,00%
Mount Acme +8.902,77%
Acmevale North −20,00%
Acmevale South
Homeport +10.817%
Longwood +9.900,300%
Meadowbrook +9.900,00%
Johnstown +11.377,47%
Lakewood +9.837,80%
Fox Hollow +9.987,67%
Riverton +10.550,24%
Timber Creek +9.539,33%
Terminated −100,00%
Upstart NA
With |invert=on
Region first second change
Big Meadow 1.830.000 190.067.975 −99,04%
Little Meadow 400.000 500.000 −20,00%
Mount Acme 2.450.000 220.567.837 −98,89%
Acmevale North 1.250.000 1.000.000 +25,00%
Acmevale South
Homeport 5.120.000 558.946.260 −99%
Longwood 930.000 93.002.792 −99,000%
Meadowbrook $2.450.000 $245.000.000 −99,00%
Johnstown 3.400.000 kg 390.234.005 kg −99,13%
Lakewood 2.250.000 223.600.556 −98,99%
Fox Hollow 1.180.000 119.034.532 −99,01%
Riverton 10.550.000 1.123.600.555 −99,06%
Timber Creek 1.360.000 131.094.830 −98,96%
Terminated 1.500 0 NA
Upstart 0 2.625.050 −100,00%
With |invert=on and |disp=out
Region change
Big Meadow −99,04%
Little Meadow −20,00%
Mount Acme −98,89%
Acmevale North +25,00%
Acmevale South
Homeport −99%
Longwood −99,000%
Meadowbrook −99,00%
Johnstown −99,13%
Lakewood −98,99%
Fox Hollow −99,01%
Riverton −99,06%
Timber Creek −98,96%
Terminated NA
Upstart −100,00%

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

Tracking

uah

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

See also

uah