I need to convert this figure below into crores:
Please suggest on how it can be achieved.
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', '.' ,',' )
Is there any way to do it by using the Custom option in the Number Formatting section?
No it's not.
Retrieving data ...