
2. Re: Calculate the difference between this year and last year without a table calculation or parameter
Wesley Magee Jun 27, 2018 8:51 AM (in response to Greg Useem)Greg,
You could approach it with a series of if/thens to arrive at each number. Something like the following:
Current Year
IF YEAR({MAX(Date)}) = Date THEN [Value] END
Prior Year
IF DATEDIFF('year', YEAR(Date), YEAR(({MAX(Date)})) = 1 THEN [Value] END
Difference
SUM(Current Year)  SUM(Prior Year)
The number of widgets produced last year was [Prior Year] and this year was [Current Year] and the difference is [Difference]
This all assumes you want to use the max year in your data as the current year. Let me know if this isn't what you're looking for.
Wesley
If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.