7 Replies Latest reply: Jun 19, 2014 1:51 PM by ANGIE DM RSS

    Sum only for full fiscal month

      Tried to get sum for all full months as shown following:



      Since 201405 has not reached to the end of the fiscal month yet. It should be ignored.


      So ideally, I just want to have total of 1100 which is sum of months of 201403 and 201404 as following



      For fiscal month, it is always 4 or 5 weeks.


      I attached .qvw file. Please advise.