4 Replies Latest reply: Aug 20, 2017 9:29 PM by Louis Lam

# KPI Object show \$ and K/M

Hi all,

I would like to show a KPI with dollar and in thousand or million dynamically.

However, i found that it could only show one of them.

Is it possible to show both dynamically?

Best Regards,

Louis

• ###### Re: KPI Object show \$ and K/M

May be this:

```='\$' &
If(Sum(Value) < 999,
Sum(Value),
If(Sum(Value) > 999 AND Sum(Value) < 99999,
Num(Sum(Value)/1000, '#,##0.##') & ' K',
If(Sum(Value) > 99999,
Num(Sum(Value)/1000, '#,##0.##') & ' M')))
```

Regards!

Rahul Pawar

• ###### Re: KPI Object show \$ and K/M

Hi,

TEXT(if(Sum(Value) >= 1000000000,  num(Sum(Value)/1000000, '\$#.##0,##M', ',', '.'),

if(Sum(Value) >= 1000000,  num(Sum(Value)/1000000, '\$#.##0,##M', ',', '.'),

if(Sum(Value) >= 1000, num(Sum(Value)/1000,  '\$#.##0,##K', ',', '.'),

num(Sum(Value), '\$#.##0,##', ',', '.')))))

If you want to use on table object, you don't need to use TEXT function.

• ###### Re: KPI Object show \$ and K/M

After using this expression, the conditional color will not work.

• ###### Re: KPI Object show \$ and K/M

Hi, another option:

=Num(Sum(Value)/Pow(10, Floor(Len(Round(Sum(Value)))-1, 3)), '\$#,##0.00')

& Pick(Floor((Len(Round(Sum(Value)))-1)/3)

, ' K'

, ' M'

)