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

    Range Expression

    naveen kumar

      Hi,

          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

       

      Capture.PNG

      CAL MONTH is derived from a date field as below

                                                                           Month(CALDAY) as "CAL MONTH"

      CALDAY is in DD-MM-YYYY formate

       

      Thanks