Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
For Utilization rate to be around 95%, you need to use: (TaskTime/SignOnTime) * 100