Abbreviated data format - no e-x terms

Hi,
We are using the abbreviated data format a lot to avoid huge numbers in KPIs. However, when you filter on e.g. single cases, numbers might become small and the abbreviated format displays something like 80.0e-3. Most of our users are rather confused by this format. In many cases it would be sufficient to go down to maximum two digits, i.e. show 3.41k but 0.08 instead of 80.0e-3 and 0.00 for 0.001. Is there a way to define the format like that or is it planned to include a new abbreviated format in the near future?
Best,
Stephanie

1 Like

Hi Stephanie,

you can try to use ROUND() function around the abbreviated value.

Let me know if this solves your problem.

Best regards,
Viana

Hi Viana,
thanks for your input. Unfortunately it doesn’t solve my problem, since 0.30 is then shown as 0.00 and if I use ROUND(x*100)/100 it is again shown as 300e-3…
Any other suggestions?
Many thanks!
Stephanie

Hi Stephanie,

can you please try
ROUND(x*100/100)

Best regards,
Viana

Hi,
this doesn’t make a difference…
Best,
Stephanie

Hi,
if anyone else has the same “problem”. I have created a quick fix that can be used for single number KPIs (for exports it’s surely not the best solution since numbers are transformed to strings and in plots it also doesn’t work). I have created a saved formula “myAbbrFormat” with one parameter (decimal), which is defined as follows:
CASE
WHEN {p1}/1000000000.0>=100.0
THEN ROUND({p1}/1000000000.0)||‘B’
WHEN {p1}/1000000000.0>=10.0
THEN ROUND({p1}/100000000.0)/10.0||‘B’
WHEN {p1}/1000000000.0>=1.0
THEN ROUND({p1}/10000000.0)/100.0||‘B’
WHEN {p1}/1000000.0>=100.0
THEN ROUND({p1}/1000000.0)||‘M’
WHEN {p1}/1000000.0>=10.0
THEN ROUND({p1}/100000.0)/10.0||‘M’
WHEN {p1}/1000000.0>=1.0
THEN ROUND({p1}/10000.0)/100.0||‘M’
WHEN {p1}/1000.0>=100.0
THEN ROUND({p1}/1000.0)||‘k’
WHEN {p1}/1000.0>=10.0
THEN ROUND({p1}/100.0)/10.0||‘k’
WHEN {p1}/1000.0>=1.0
THEN ROUND({p1}/10.0)/100.0||‘k’
WHEN {p1}>=100.0
THEN ROUND({p1})||’’
WHEN {p1}>=10.0
THEN ROUND({p1}*10.0)/10.0||’’
ELSE ROUND({p1}*100.0)/100.0||’’
END

Best,
Stephanie

PS: However, I still think it would be a good extension to include a more flexible abbreviated format!

1 Like