Variable displaying

[RKULKARNI4]

Hello Team,

 I have one field in Qlik sense report it is showing 5 digit.The below  formula i have used :

Num(Amt,'0.00###') AS "Original Currency Rate of Exchange to Currency",

But when i export into excel it is showing only 2 digit decimal 1.11.

I need to showing 5 digit like 1.11111.

Please advise .

Regards

RK

[Chanty4u]

can you try this?

Num#(Num(Amt,'0.00###'))

[Gabriel]

@RKULKARNI4 

Try 

NUM#(NUM(SUM( Amt),'#0,000'))