KPI Object show $ and K/M

[Anonymous]

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

[rahulpawarb]

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

[kaanerisen]

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.

[rubenmarin]

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'

  )

[Anonymous]

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