Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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!