Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a table that shows each employee and average pick rate pr 10 min.
i.e:
Employee | 09:00 | 09:10 | 09:20 | 09:30 | 09:40 | 09:50 | 10:00 | 10:10 | 10:20 |
---|---|---|---|---|---|---|---|---|---|
Emp1 | - | 23 | 27 | 22 | 33 | - | 23 | 32 | - |
Emp2 | - | 34 | 30 | 19 | - | - | - | 34 | 21 |
Emp3 | 22 | 29 | 20 | 33 | - | 30 | 23 | - | - |
I need to create a second table that gives me the number of slots when empXX actually picked
Employee | Picks |
---|---|
Emp1 | 6 |
Emp2 | 5 |
Emp3 | 6 |
Any easy way to solve this?
BR
Dan
Tried that but not the result I needed.
field notation:
usr = userid
slot date= dategroup
nnumber: qty
I then tried:
Count(If(not isnull(userid),userid)) but the result is 49.
Should be 10
try it with isnull(userid) = 1 that means not null and usually works i always have problems with the not hope this helps
regards,
MT
sorry isnull(...) = 0 my mistake