Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to write set analysis to calculate for items where the Year(date) on the line level is < Max(Year(Date))
Not much to show as of yet so all recommendations are welcomed.
Thank you,
- dave
Count( DISTINCT {<Date = {"=Year(Date)<$(=Max(Year(Date)))"}>} Item#)
To clarify:
For instance
Item#,Date
1, 1/15/2014
2, 2/10/2014
3, 2/11/2016
4, 3/04/2016
5, 7/23/2015
I want to only count items where the year of the date field is less than the max year of the whole date field.
In the example above I would only want to count item # 1,2 and 5
Count( DISTINCT {<Date = {"=Year(Date)<$(=Max(Year(Date)))"}>} Item#)
thank you!