round up on KPI

l26b — Thu, 20 Mar 2025 08:39:57 GMT

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

Re: round up on KPI

Chanty4u — Thu, 20 Mar 2025 16:38:01 GMT

Try this

If(Sum(Volume) >= 1000000,

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

If(Sum(Volume) >= 1000,

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

Ceil(Sum(Volume))

)