Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are trying to compare current year YTD vs Prev year YTD. Lets say we are in month of May 2014 so current year YTD would be Jan to May 2014 revenue. And we need to compare this with previous yr YTD revenue which should be Jan to May 2013 so how can we write and expression so that the prev year YTD will calculate only these 5 months Jan to May 2013 and exclude rest while calculating revenue?
Several ways are there. A better one : Year Over Year Comparison
Write like
For Current YTD
=SUM({$<YourDateField = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}Sales)
For Previous YTD
=SUM({$<YoureDateField = {'>=$(=AddMonths( YearStart (Today()),-12))<=$(=AddMonths( MonthEnd (Today()),-12))'}>}Sales)
Current Year- Sum({<Date={">=YearStart(Today())<=$(=Today())"}>}Sales)
Previous Year- Sum({<Date={">=$(=YearStart($(=MakeDate(Year(Today())-1,Month(Today()),Day(Today())))))<=$(=MakeDate(Year(Today())-1,Month(Today()),Day(Today())))"}>}Sales)
Hello @Anand Chouhan
I used your code:
=Count({$<BookingDate = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}AssignmentNumber)
=Count({$<BookingDate = {'>=$(=AddMonths( YearStart (Today()),-12))<=$(=AddMonths( MonthEnd (Today()),-12))'}>}AssignmentNumber)
It works perfectly.
Then I wanted to add another preceding year.. Following same form.. but this did not work at all.. Any idea how to make this work?
=Count({$<BookingDate = {'>=$(=AddMonths( YearStart (Today()),-24))<=$(=AddMonths( MonthEnd (Today()),-24))’}>}AssignmentNumber)
Thanks
/Oskar