3 Replies Latest reply: Aug 1, 2013 3:36 AM by vishal waghole RSS

    IF FUNCTION

    Adotey Kwame

      Hi!

      This expression returns SALES for only D instances, and i would want both C and D.

       

      = SUM(IF(LEFT([FIELDNAME],1) = 'C','D', (SALES)))

       

      Thanks