0 Replies Latest reply: Nov 9, 2017 12:28 AM by Divyanshi Bansal RSS

    want maximum month for a quarter?

    Divyanshi Bansal

      I have a Quarter filter and want to display the data of last month of selected Quarter.

       

      I get this by using below expression  :

       

      Expr 1:

       

      (text(Date(Date#(if($(exit_month)=12,$(exit_month)-9,$(exit_month)+3),'MM'),'MMM')))

       

      where

       

      exit_month :

      Expr 2:

      max((If(num(month(date#(Mon,'MMM')))<4,num(month(date#(Mon,'MMM')))+9,

      num(month(date#(Mon,'MMM')))-3)),'MM')

       

      By using Expr 1 , I am able to get the last month for the selected Quarter.

      Now I want that if I select two Quarter then I should last month of both the respective Quarters.

      i.e.

      if I select Q1 and Q2 then I should get June and September resp where Q1={Apr,May,Jun} and Q2={Jul,Aug,Sep}.

       

      I am trying to use the Expr 1 in  concat function as :

       

      concat(distinct (text(Date(Date#(if($(exit_month)=12,$(exit_month)-9,$(exit_month)+3),'MM'),'MMM'))),',')

       

      But not getting the result. Kindly help.