Wrong percentage calculation in table

[flemmingbj]

Hi,

I get a wrong percentage calculation in my table for two time variables in the example below. The Utilization rate is SignOnTime divide by TaskTime .

When I export the data to Excel I get the correct percentage - why does Qlik calculate it wrong?

[sk88024]

For Utilization rate to be around 95%, you need to use: (TaskTime/SignOnTime) * 100