How to Covert Dimension values format

kunkumnaveen — Tue, 28 May 2019 12:00:29 GMT

Hello All,

I have got a Dimension( Number) and the values are like

Number

900000

1000000

1100000

1200000

.....and So on

so how to achieve in below format

Require Out Put

Number

9Lak

10Lak

11Lak

12Lak

....so on

Thanks

Re: How to Covert Dimension values format

jonathandienst — Tue, 28 May 2019 12:31:44 GMT

Many ways to do this, variations on

= Floor(Number / 100000, 0) & 'Lak'

Ceil, Round, Num() are all alternatives.