Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you try this?
Num#(Num(Amt,'0.00###'))