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.

       

      Thanks.