This content has been marked as final. Show 3 replies
attach you woork book
3 of 3 people found this helpful
Build calculated field:
Non-Future Current Year Sales
IF [Order Date]<TODAY() AND YEAR([Order Date])=2018 THEN [Sales] END
Use it instead of Current Year Sales.
Hope it helps.