Template documentation[view] [edit] [history] [purge]

Use

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

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.

Tracking

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

See also