1. Home
  2. Docs
  3. Ajelix BI
  4. Get Started
  5. Custom number formatting

Custom number formatting

Custom Text (Useful for currencies)

NumberFormatResult
100{€ }0€ 100
300{Â¥ }0Â¥ 300
971620.00a{ USD}97.17k USD

Numbers

NumberFormatResult
100000,0.000010,000.0000
10000.230,010,000
10000.23+0,0+10,000
-100000,0.0-10,000.0
10000.12340.00010000.123
100.12340000000100
1000.1234000000,0001,000
10000.00010.00
10000.12340[.]0000010000.12340
-10000(0,0.0000)(10,000.0000)
-0.23.00-.23
-0.23(.00)(.23)
0.230.000000.23000
0.230.0[0000]0.23
12309740.0a1.2m
14600 a1 k
-1040000a-104k
10o1st
1000o100th

Currency

NumberFormatResult
1000.234$0,0.00$1,000.23
1000.20,0[.]00 $1,000.20 $
1001$ 0,0[.]00$ 1,001
-1000.234($0,0)($1,000)
-1000.234$0.00-$1000.23
1230974($ 0.00 a)$ 1.23 m

Bytes

NumberFormatResult
1000b100B
10240b1KB
20480 ib2 KiB
30720.0 b3.1 KB
78844862130.00b7.88GB
34674796827870.000 ib3.154 TiB

Percentages

NumberFormatResult
10%100%
0.9748782340.000%97.488%
-0.430 %-43 %
0.43(0.000 %)43.000 %

Time

NumberFormatResult
2500:00:000:00:25
23800:00:000:03:58
6384600:00:0017:44:06

Exponential

NumberFormatResult
11234567890,0e+01e+9
12398734.2020.00e+01.24e+7
0.0001239870.000e+01.240e-4