7 Replies Latest reply: Jan 30, 2017 10:55 AM by Sunny Talwar RSS

    IF Statement - Chart Help

    Sara Titmuss

      Afternoon all,

       

      I have a basic straight table which is pulling sales lead information.  This table is an overview of top accounts by value etc.  It should be pulling through the top accounts for a sales person when selected, but it's not.  It's pulling all data!!

       

      I imagine I need to put some sort of IF statement in but struggling to get it to work.  So for example Count(IF(name = ' ',OPPORTUNITY_COUNT) this doesn't work......any advice?