FORMATTING NUMBERS IN LEGALSUITE

Numbers are stored in their “raw” form in the SQL database (e.g. 1234.56). To display them in different formats you can use the FORMAT() function with a picture token, For example:

[[(FORMAT(MAT:ClaimAmount,@N~R~15.2))]]

Some commonly used picture tokens are:

Picture Token	Result	Description
@N9.2	4,550.75	Two decimal places, period decimal separator
@N_9.2B	4550.75	Two decimal places, period decimal separator, no grouping, blank if zero
@N_9'2	4550,75	Two decimal places, comma decimal separator
@N9.'2	4.550,75	Comma decimal separator, group with periods
@N9_'2	4 550,75	Comma decimal separator, group with spaces,
@N-9.2B	-2,347.25	Leading minus sign, blank if zero
@N9.2-	2,347.25-	Trailing minus sign
@N(10.2)	(2,347.25)	Enclosed in brackets when negative
@N~R~15.2B	R2,347.25	Leading Rand sign, blank if zero
@N~R~15.2-	R2,347.25-	Leading Rand sign, trailing minus when negative
@N~R~(15.2)	R(2,347.25)	Leading Rand sign, in brackets when negative