6 Replies Latest reply: Apr 19, 2018 10:00 AM by Sunny Talwar RSS

    Unable to to sum based on current year vs last year to date

    Majid Bhatti

      Hi, I am new to QS. I have data for year 2017 & 2018 in a table. what i am try to do is take SUM of all transactions up to TODAY but only for current year. I am trying to prepare comparison of current YTD vs Last YTD .

       

      I have tied all sort of YTD & LY TD formulas Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year) but none seems to be working

       

      Attached is my detailed ! .QVF file