0

If the character in the position of the 0 is a number, the number is used. If not, a zero is used.

0#### →
01350

#

If the character in the position of the # is a number, the number is used. If not, no value is placed in this position.

If the number of # and 0 that is placed before the decimal point is lower than the value to be shown, the complete value is shown.

##### →
1350

## →
1350

.

A decimal point. This is used to indicate that you want to include numbers after the decimal point in the report. The decimal point is used depending on the locale of the Planon language used by the logged in user.

If the number of # or 0 placed after the decimal point is less than the number of decimal places to be shown, the value is rounded up or down. This also applies if no numbers are used after the decimal point.

####.#00 →
1350.45

#.## →
0.26

0.26 →rounded up to 0.3

,

For numbers over 999 a separation mark is used. The grouping symbol is determined by the locale of the Planon language used by the logged in user.

#,### →
1,350

‘ ’

Text placed between single quotation marks is included in a report.

‘The United Kingdom has’ #.### ‘points.’ →
The United Kingdom has 1.350 points.

;

This enables you to specify that you want to use different masks for positive values, negative values or the value zero. The different formats are separated by a semicolon (;). The first format applies to positive values, the second to negative values and the third to the value zero.

####;
-0####;0000
1350 → 1350
–1350 → -01350
0 → 0000