5 Replies Latest reply: Dec 15, 2017 5:05 AM by Sunny Talwar RSS

    Range Expression

    naveen kumar


          Currently we are in FY-2018,December Month ,so if FY-2017 is selected then I need to consider entire year volume (Apr to March),

      if FY-2018 is selected then I need to consider only  8 months volume (Apr-Nov),December month volume should not be considered ,In January month ,till December volume I need to considered ....so on


      How to write this expression Dynamic from below data



      CAL MONTH is derived from a date field as below

                                                                           Month(CALDAY) as "CAL MONTH"

      CALDAY is in DD-MM-YYYY formate