https://community.qlik.com/t5/App-Development/DIsplay-values-not-rounded-in-crosstab/m-p/1739071#M64066 <P>I have an issue with rounding.&nbsp; &nbsp;my calculation shows me the correct value but when I change the format it is automatically rounded</P><P>my calculation floor(7359/7467, '0.0001)&nbsp; will return 0.9855 what is the correct value.&nbsp;<BR />This is a percentage value, when I change the format pattern to&nbsp;#,##0.0% it will automatically change this to 98.6%.&nbsp; Is there a way to display 98.5% in the crosstab</P> Sat, 16 Nov 2024 18:10:56 GMT geertdeman 2024-11-16T18:10:56Z https://community.qlik.com/t5/App-Development/DIsplay-values-not-rounded-in-crosstab/m-p/1739071#M64066 <P>I have an issue with rounding.&nbsp; &nbsp;my calculation shows me the correct value but when I change the format it is automatically rounded</P><P>my calculation floor(7359/7467, '0.0001)&nbsp; will return 0.9855 what is the correct value.&nbsp;<BR />This is a percentage value, when I change the format pattern to&nbsp;#,##0.0% it will automatically change this to 98.6%.&nbsp; Is there a way to display 98.5% in the crosstab</P> Sat, 16 Nov 2024 18:10:56 GMT https://community.qlik.com/t5/App-Development/DIsplay-values-not-rounded-in-crosstab/m-p/1739071#M64066 geertdeman 2024-11-16T18:10:56Z