Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

Variable displaying

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

 

 

2 Replies
Chanty4u
Champion III
Champion III

can you try this?

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

Gabriel
Partner
Partner

@RKULKARNI4 

Try 

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