Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody,
I have another small problem with a calculation. (I'm working with Qlikview version 12)
From the source I receive a value in seconds for the field PA_SecondsWorked (I format this to hours in the script and treat it as an interval type)
The second field PL_Nr_Of_Cases contains integer values.
I want to calculate the productivity but it's giving 0 back as result:
[PL_Nr_Of_Cases] / [PA_SecondsWorked]
Somewhere I'm doing something wrong but I don't see it, can any of you help please?
I'm attaching the qvw to see what I've been doing.
Kind regards,
Monique
Hi Monique,
You need an aggregation function like Sum() because there are two possible values for the one warehouse code so e.g.
Sum([PL_Nr_Of_Cases]) / Sum([PA_SecondsWorked])
Hi Monique,
You need an aggregation function like Sum() because there are two possible values for the one warehouse code so e.g.
Sum([PL_Nr_Of_Cases]) / Sum([PA_SecondsWorked])
Hi Piet Hein,
This does the trick, thanks a lot for the great help.
Kind regards,
Monique