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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Decimal

=Sum(num_leads)  / Sum(num_users).  I have this expression.  Right now it returns 1 but I need it to be 1.25 and can't get it to show me the decimal value. 

Any suggestions?

Labels (1)
1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi,

You can use this : NUM(Sum(num_leads)  / Sum(num_users),'0.00')

Regards,

Sokkorn Cheav

View solution in original post

3 Replies
Not applicable
Author

In properties,there is a sheet "number". You can set 2 decimal here.

Sokkorn
Master
Master

Hi,

You can use this : NUM(Sum(num_leads)  / Sum(num_users),'0.00')

Regards,

Sokkorn Cheav

Not applicable
Author

num(Sum(num_leads)  / Sum(num_users),'#0,00')