This is great. However, I work on a fiscal calendar. So I need to use a formula that states something like - If date is between XX and XX then '2014 YTD', ELSE '2015 YTD'
I just tried this formula:
IIF([Invoice Date] >= #07-01-2014#
AND [Invoice Date] <= #06-30-2015#, '2014 YTD', '2015 YTD')
But it does not give me a SUM of units. It provides me a distinct count
Could be something like this:
IF [Order Date] >= DATE("10/1/2012") AND [Order Date] <= DATE("9/30/2013")
THEN [Sales] END
I just figured it out -
AND [Invoice Date]<=#06-30-2015#,[Converted Units],0))
This formula gives me exactly what I want.
Thank you Adam for your support!