Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to compare the number of Quote of the last year(From the year begin to the max QuoteDate in current year) to current year YTD, the current year can be choosed in the filter panel.
For example, the max QuoteDate of current year is 10/10/2017,If I choose 2016 in the filter panel, I want to see the Quote numbers from 1/1/2015 to 10/10/2015
I use this :
Count( distinct [QuoteNo] )-Count({<[QuoteDate.autoCalendar.Year]={"$(=(year(([QuoteDate.autoCalendar.Year]))-1))"},[QuoteDate.autoCalendar.Year]=>} distinct [QuoteNo] )distinct [QuoteNo] ) but it not work ......
May be this
Count(DISTINCT {<QuoteDate = {"$(='>=' & Date(YearStart(Max(QuoteDate), -1), 'MM/DD/YYYY') & '<=' & Date(SetDateYear(Max({1} QuoteDate), QuoteYear - 1), 'MM/DD/YYYY'))"}>} [QuoteNo])
Sorry for reply late,It shows 0,but I learned a function SetDateYear, thank you all the same