Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shivalid
New Contributor III

Number Conversion

Hi

I need to convert this figure below into crores:

35.85G


Please suggest on how it can be achieved.

Thanks.

3 Replies
MVP
MVP

Re: Number Conversion

Its 3585 crores....

So if the number is stored in Qlik as the the acutal number which is 35,850,000,000 and displayed as 35.85G you can format it explicitly like this:

Num( Sum(theField)/10000000  , '0.00', '.' ,',' )

shivalid
New Contributor III

Re: Number Conversion

Is there any way to do it by using the Custom option in the Number Formatting section?

MVP
MVP

Re: Number Conversion

No it's not.

Community Browser