8 Replies Latest reply: Jul 20, 2015 9:50 PM by Shan Ahmed RSS

    Calculating Current YTD amounts for Current Year and Previous Year Excluding the current month

    Shan Ahmed

      Hi All,

       

      I would really appreciate of any kind of help in this problem.

       

      I have a scenario where i have to calculate the sum of Line amount for the Current year and previous year excluding current month.

       

      But for the Previous year calculation it will show only the months that are completed in 2015.

       

      So in summary:

      Line Amount in 2015(Actual 2015): Sum of all months excluding Current month

      Line Amount in 2014(Actual 2014): Sum of All months(All months of 2015) excluding the current month (The month is current for 2015)

       

      Please let me know if you have any questions.

       

      Thanks in advance.

       

      Ahmed