Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
francisvandergr
Partner - Creator II
Partner - Creator II

Problem with decimals

In my load statement i have the following set statement for money :

SET MoneyFormat='#.##0,00;-#.##0,00';

This works good, but now i have a text box with a formula for example:

=money(sum(48/49)) The result of this formula i want in 5 decimals. How can i do that ?

1 Solution

Accepted Solutions
renjithpl
Specialist
Specialist

Try this

=



Num(money(sum(48/49)), '#.######')

Regards

Ren

View solution in original post

2 Replies
renjithpl
Specialist
Specialist

Try this

=



Num(money(sum(48/49)), '#.######')

Regards

Ren

francisvandergr
Partner - Creator II
Partner - Creator II
Author

Thanx it worked!