i-net Clear Reports
Properties and Formulas for Formatting Number Values
This report shows the various properties and formulas which can be used for formatting number values. Custom formatting is possible instead of using the system default format.
Such a background indicates that the field formatting is done by a formula.
Rounding
12,345.6800
12,345.6789
The blue number should be rounded to 4th decimal place
12,346.0000
12,345.6800
The blue number should be rounded to.zero decimal places.
12,000.0000
12,345.6800
The blue number should be rounded to thousands.
12,345.6789
12,345.6800
The blue number should be rounded to 4th decimal place as the property formula for "rounding" returns 4.
12,346.0000
12,345.6800
The blue number should be rounded to zero decimal places as the property formula for "rounding" returns 0.
12,000.0000
12,345.6800
The blue number should be rounded to thousands as the property formula for "rounding" returns -4.
N decimal places
12,345.68
12,346
The blue number should have zero decimal places.
12,346.0
12,345.68
The blue number should have one decimal place.
12,346.00
12,345.68
The blue number should have two decimal places.
12,346.000
12,345.68
The blue number should have three decimal places.
12,345.68
12,346
The blue number should have zero decimal places as the property formula for "n decimal places" returns 0.
12,346.0
12,345.68
The blue number should have one decimal place as the property formula for "n decimal places" returns 1.
12,346.00
12,345.68
The blue number should have two decimal places as the property formula for "n decimal places" returns 2.
12,346.000
12,345.68
The blue number should have three decimal places as the property formula for "n decimal places" returns 3.
© Copyright 1996 - 2025, i-net software GmbH; All rights Reserved.
Page 1 of 8

i-net Clear Reports
Negatives
-12,345.68
-12,345.68
The blue number should have the same value like the black one and the minus sign should be visible as prefix.
-12,345.68
12,345.68-
The blue number should have the same value like the black one and the minus sign should be visible as suffix.
-12,345.68
(12,345.68)
The blue number should have the same value like the black one and there should be simple brackets around the number.
-12,345.68
12,345.68
The blue number should have the same value like the black one and the minus sign should not be visible.
-12,345.68
-12,345.68
The blue number should have the same value like the black one and the minus sign should be visible as prefix as the property formula for negatives returns leadingminus.
-12,345.68
12,345.68-
The blue number should have the same value like the black one and the minus sign should be visible as suffix as the property formula for negatives returns trailingminus..
-12,345.68
(12,345.68)
The blue number should have the same value like the black one and there should be simple brackets around the number as the property formula for negatives returns bracketednegatives.
-12,345.68
12,345.68
The blue number should have the same value like the black one and the minus sign should not be visible as the property formula for negatives returns nonegativesign.
-12,345.68
-12,345.68
The blue number should have the same value like the black one and the minus sign should be visible as prefix as the property formula for negatives returns crleadingminus.
-12,345.68
12,345.68-
The blue number should have the same value like the black one and the minus sign should be visible as suffix as the property formula for negatives returns crtrailingminus.
-12,345.68
(12,345.68)
The blue number should have the same value like the black one and there should be simple brackets around the number as the property formula for negatives returns crbracketednegatives.
-12,345.68
12,345.68
The blue number should have the same value like the black one and the minus sign should not be visible as the property formula for negatives returns crnonegativesign.
© Copyright 1996 - 2025, i-net software GmbH; All rights Reserved.
Page 2 of 8

i-net Clear Reports
Decimal separator
12,345.68
12,345@68
The blue number should have a @ as decimal separator.
12,345.68
12,345€68
The blue number should have a € as decimal separator as the property formula for "decimal separator" returns '€'.
© Copyright 1996 - 2025, i-net software GmbH; All rights Reserved.
Page 3 of 8

i-net Clear Reports
Thousands separator and thousands separato
12,346
12,346
The blue number should contain a thousands separator.
12346
12,346
The blue number should not contain a thousands separator as the property is set to false.
12,346
12,346
The blue number should contain a thousands separator as the property formula for "thousands separator sign" returns true.
12346
12,346
The blue number should not contain a thousands separator as the property formula for "thousands separator sign" returns false.
12@346
12,346
The blue number should contain the thousands separator.sign @.
12,346
12€346
The blue number should contain the thousands separator.sign € as the property formula for "thousands separator sign" returns '€'.
© Copyright 1996 - 2025, i-net software GmbH; All rights Reserved.
Page 4 of 8

i-net Clear Reports
Reverse sign for display
12,345.68
-12,345.68
-12,345.68
12,345.68
The blue numbers should have the opposite sign of the black numbers.
-12,345.68
12,345.68
12,345.68
-12,345.68
The blue numbers should have the opposite sign of the black numbers as the property formula for "reverse sign for display" returns true.
-12,345.68
-12,345.68
The blue numbers should have the same sign like the black numbers as the property formula for "reverse sign for display" returns false.
12,345.68
12,345.68
© Copyright 1996 - 2025, i-net software GmbH; All rights Reserved.
Page 5 of 8

i-net Clear Reports
Suppress if zero
0.00
The blue number should be not visible as the number is zero and should be suppressed.
0.00
The blue number should be not visible as the property formula for "suppress if zero" returns true.
0.00
0.00
The blue number having the same value like the black one should be visible as the property formula for "suppress if zero" returns false.
© Copyright 1996 - 2025, i-net software GmbH; All rights Reserved.
Page 6 of 8

i-net Clear Reports
Show zero values as
0.00
-
There should be a blue minus (-) character visible.
0
0.00
There should be a blue zero (0) visible.
© Copyright 1996 - 2025, i-net software GmbH; All rights Reserved.
Page 7 of 8

i-net Clear Reports
Use leading zero
0.50
0.50
There should be a blue number with the same value like the black one as "use leading zero" is true.
.50
0.50
There should be a blue number without the leading zero as "use leading zero" is false..
0.50
0.50
There should be a blue number with the same value like the black one as the property formula for "use leading zero" returns true.
.50
0.50
There should be a blue number without the leading zero as the property formula for "use leading zero" returns false.
© Copyright 1996 - 2025, i-net software GmbH; All rights Reserved.
Page 8 of 8