I'm working on building an app that displays shows the share of cases considered satisfactory ('Sat') to all cases. I'm using the below code:
Count({<[CSRcall_combine.OverallScore] = {'Sat'}>}[CSRcall_combine.Eval_Dim_ID])/Count([CSRcall_combine.Eval_Dim_ID])
I am trying to validate the result against the data source, and I am seeing that for one month, I have the result 83.6% in my source data, but I have 83.5% in Qlik. I changed the format to include more decimal places, and it seems that the result in my source data and in Qlik is 83.55%. For some reason, Qlik is rounding this down rather than up to 83.6%. Does anyone know of a way to change the system settings so that they automatically round 5's up rather than down?
