Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am replacing chart expression
Count(DISTINCT if(Hours>0 AND Job <>1 AND NOT match(PersonID,1,2,20,21,22,23,24,25,26,27,28,29,998,999),Person_Name))
by set analysis.... how to add NOT MATCH condition in set analysis expression. Ia m trying something like this
=count({$<PaidDate=P(Date), Hours={'>0'}, Job={'<>1'}, PersonID{'<>{1,2,20,21,22,23,24,25,26,27,28,29,998,999}'} >} DISTINCT Person_Name)
And also like this
=count({$<PaidDate=P(Date), Hours={'>0'}, Job={'<>1'},PersonID={'=NOT MATCH(PersonID,1,2,20,21,22,23,24,25,26,27,28,29,998,999)'} >} DISTINCT Person_Name)
Thanks in Advance
even i am using the same version... but i see 157 in all rows...