9 Replies Latest reply on Nov 8, 2013 12:34 PM by Steve Gesuale

    calc for YTD/last day entered

    Steve Gesuale

      Hi,

       

      I am tracking daily sales against daily targets blended from two workbooks in which targets are pre-entered through the end of the year and sales are entered daily – but usually a few days behind the actual day. I’ve got bullet charts using YTD and MTD calc’s but I want to change TODAY() to be not “today” but the last day of sales entered.

       

      IF[Date]<=TODAY() and DATEDIFF('year',[Date],TODAY())=0 THEN [Target] END

      IF[Date]<=TODAY() and DATEDIFF('year',[Date],TODAY())=0 THEN [Sales] END

       

      Any suggestions for revising this so it returns YTD through the last day of Sales entered, rather than “today”?

       

      Thanks as usual!

      Steve