5 Replies Latest reply: Oct 5, 2014 12:00 PM by Ashfaq Mohammed RSS

    Excluding selected range

      Hi to Everyone.

      I have a chart with these fields:




      -invoice number



      QUANT  (the expression is : sum({$<YEAR-={$(YEAR)}>} PPC_IVQUANT)


      I have two field for selection YEARS and MONTHS.

      What I want to do, is to exclude from this tabe  lines where the date falls on the selected dates  range ( The test here is for the year only, but it didnt work out).

      I couldnt it solve it after many times. Please consider that the user can selected some months together.

      I can't use "1-$ " becuse I want the results to  regard the  selected product in a nother field/


      I will appriciate any help/


      Thnak you,

      Osher Sassoni.