5 Replies Latest reply: Jun 26, 2013 2:19 PM by Jasleen Puri RSS

    Sumif not working

      i want to sum the field cost for all entries where the posting date is less than 31/12/2010 and ignore the entries where the posting date is after that date.

       

      for eg, Rs. 100,000 is spent in 2009, 2010, 2011, 2012, then it should show Rs. 2,00,000.

       

      but iam getting value of Zero.

       

      Below is the expression, pls help.

       

       

      Sum (IF(PD <= 31/12/2010,[Cost Amount (Actual)],0))