Hi there,
i have something really weird happening, i have tried to figure out the reason but with no luck.
i have a slice which filter rows according to this condition:
and(in([SKU Item],select(Create PickList[SKU Item],true)),
in([id],top(select(BIN Products[ID],[SKU Item]=[_thisrow].[SKU Item]),[_thisrow].[to be picked quantity])))
this slice is taken from the table BIN Products and it called Picklist.
the condition is working fine and i can see the results that i want.
the issue is i want to count the number of rows inside the slice and it should be simple like :
count(Picklist[_rownumber])
but the results is always zero. i can count records for any other slice only this slice that always give zero
any ideas ?
Where is the COUNT() expression being used? Please post a screenshot.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |