14 Replies Latest reply: Jul 13, 2017 7:54 AM by Sunny Talwar RSS

    If  with Count and Sum

    shweta gupta

      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