11 Replies Latest reply: Jun 15, 2012 2:45 AM by thijsjan RSS

    Sum if field not starts with cm

      Hi,

       

      I want to sum the field 'price' if the field 'type' does not start with cm.

      And I also want to sum a other field if the orderDate is between the chosen date and 10 weeks before the chosen date.

       

      I tried to modify this =SUM({$<Year={$(=Only(Year)-1)}>} Sales) to make it work but I can't get it to work.

       

      Kind regards,