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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
geertdeman
Contributor III
Contributor III

DIsplay % values not rounded in crosstab

I have an issue with rounding.   my calculation shows me the correct value but when I change the format it is automatically rounded

my calculation floor(7359/7467, '0.0001)  will return 0.9855 what is the correct value. 
This is a percentage value, when I change the format pattern to #,##0.0% it will automatically change this to 98.6%.  Is there a way to display 98.5% in the crosstab

Labels (2)
0 Replies