Number Conversion

[Anonymous]

Hi

I need to convert this figure below into crores:

35.85G

Please suggest on how it can be achieved.

Thanks.

[petter]

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', '.' ,',' )

[Anonymous]

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

[petter]

No it's not.