Number formatting properties (AskiaVista)

These properties allow you to define how the numbers in your calculation will be displayed. The following properties are available:

Number of decimals

Specify the number of decimals you require, if you want the counts to appear with decimal values. For example, the number 150 will be displayed as 150.00 if you indicate 2 decimals.

Show percentage sign

If you select this option, the % sign will appear to the right of count values. For example, 150 will become 150%.

Wrap text in parenthesis

If selected, this option causes counts to be surrounded by parentheses. For example, 150 becomes (150).

Replace zero by

If you require a custom character to be displayed in place of null counts, select enable in the drop-down list, and enter that character in the adjacent box. Select disable to deactivate this option.

Replace value

If selected, values less than or equal to the first specified number will be replaced with the second value you specify.

Create your own Knowledge Base