I put a slice filter and test it. The result looks correct. But when I enable it to UX. It seem not right.
My formula on slice filter is below
and([Delivery Date] >= Today() - 8, in([Store], lookup(useremail(), “Access Setup V2”, “Email”, “Access Store”)))
Solved! Go to Solution.
This is a known issue with the combination of Slice and LOOKUP() when the target column is an EnumList. Workaround is to create a virtual List column with a LOOKUP() formula and then use that with the Slice.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |