Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Fellas,
I need to show a list of user visiting to a particular dealer when my visit count >3 and Qty Sold =0.
I am writing this in dimension: =If(Count({<status={'Active'}>}fe_ref_num)>3 and Sum(qty sold)=0, User)
Please suggest me how to show this and what is wrong with the condition stated above.
Thanks in advance
Not Working!
It is still showing users with count less than 3.
Can you provide sample app or few lines of sample data?
Did this not work for you ( mrkachhiaimp's suggestion above)
Count({<User = {"=SUM(qty)=0 and count({<status = {'Active'}>}[fe_ref_num])>3"}>}Distinct User)
I need to restrict dimension!
Though If I have used this to checkout the list of the user with count 1.
it is not restricting the user with qty=0 and visit count>3
Got it, how about this (as mentioned by antoniotiman)
=Aggr(If(Count({<status={'Active'}>}fe_ref_num) > 3 and Sum(qty sold) = 0, User), User)