Money Formatting in QlikSense

[VarshaTyagi_1]

Hi Experts,

I have the Transaction Amount as ₹72,234,435,457 . Here I want to format it as ₹72,23,44,35,457. I tried using the formatting as ₹#,#0,##0 but it is not working as expected. Could you please help here.

Thanks in advance!

[BrunPierre]

Post the Qlik document.

[N30fyte]

The Custom format pattern (not Money): 

₹##,##,##,##,##,##,###

Works for me up to 15 decimal places:

Presumably because my figure has 15 decimal places.

If my figure has more than 15 decimal places then it is displayed with an exponential.

So if you anticipate larger numbers, then you will need to add additional sequences of

,##

to your custom format.

[VarshaTyagi_1]

Hi @N30fyte 

In table/KPI, the above solution is working fine.

But when I am trying the same approach for Bar chart it is not working.