2 Replies Latest reply on Feb 27, 2017 11:46 AM by . Indumon

    YTD Excluding this Month - Unless January then show Last Year

    Josh Delekta

      Hello,

       

      I had previously asked this question and implemented a calculation that didn't seem to work for me. I currently have:

       

      DATEDIFF('month',[Accounting Date],Today()) > 0 AND DATEDIFF('year',[Accounting Date],Today())= 0

       

      This is what I call "YTD Excluding this Month". Is there a way to leverage the calc above so that in January the view doesn't come up blank? I'd like to show all of last year's info in January and then go back to YTD excluding the month once in February. Any thoughts? Thank you!