round up on KPI

[l26b]

hi,

I have a few kpis measuring sum of certain volumes that go from 10 K to 100 M. 

I currently show the numbers in KPI as 12.5 K / 54.5 M but I want to round up the numbers and use 12k, 54M

how I can do that to assure that the round up will happen even if it is a small volume or in millions? 

thanks

[Chanty4u]

Try this 

If(Sum(Volume) >= 1000000, 

    Ceil(Sum(Volume) / 1000000) & 'M', 

    If(Sum(Volume) >= 1000, 

        Ceil(Sum(Volume) / 1000) & 'K', 

        Ceil(Sum(Volume))

  )

)