This article shows the most common number formats used in Ytica. You can copy and paste examples in this article to measures, reports and dashboards number formats.

Numbers

Raw integer number:

0

Natural integer with thousand separators such as 1,234  or 12,345,678 :

#,##0

One decimal number with thousand separators:

#,##0.0

Two decimal number with thousand separators:

#,##0.00

Large Numbers

This shortens a large numbers and makes them easier to read. For example 4.6B , 5.8M , 145.4K . Numbers below one thousand are shown as exact integers.

General purpose large number:

[>=1000000000]#,,,.0B;
[>=1000000]#,,.0M;
[>=1000]#,.0K;
[>=0]#,##0;
[<=-1000000000]-#,,,.0B;
[<=-1000000]-#,,.0M;
[<=-1000]-#,.0K;
[<0]-#,##0

Duration

Duration formats take number in seconds and show them in hours, minutes and seconds.
Duration in hours such as 1h 23:45  or 12:34  when shorter than one hour:

[>=3600]{{{3600||#}}}h {{{60|60|00}}}:{{{|60|00}}};
[>=0]{{{60|60|00}}}:{{{|60|00}}};
[<0]-{{{60|60|00}}}:{{{|60|00}}};

Percentages

Percentage convert numbers in range from 0.0  to 1.0  into more natural format 0%  to 100% . Use the below samples for the format you need.

Integer percentages:

0%

One decimal percentages:

0.0%

Two decimals percentages:

0.00%
Did this answer your question?