Discussion board where members can get started with QlikView.
Please could you assist with this expression: the correct answer should be 2.47 wks but i keep getting 2.85 wks
If i activate the 'Sum of ROWS' function under 'Total Mode' in the expression tab - i get the correct answer.
However i do not want to 'overide' the function as i need the correct answer to reflect in the calculated text object as well
Sum([Total Hours Taken (Leave)])/Avg([Hours - 4 Week Average])
At a line level all the values are correct - but the sum values for 'Leave Taken - 4' and 'Leave Balances - 4' are incorrect
Go to Solution.
Fixed in script - thanks!!