Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to compare sum(sales) for current day vs last year same day.
Ex: Today is Friday ,second week of march 3/10/2017 with this date sales i need to compare last year Friday ,second week of march 3/11/2016.
Thanks..
Try like this,
Current Year Date: =Sum({$< SoldDate={"$(=Date(Max(SoldDate),'M/D/YYYY'))"}>} ITEMSOLD01)
Prev. Year Date: =Sum({$< SoldDate={"$(=Date(AddYears(max(SoldDate)+1,-1),'M/D/YYYY'))"}>} ITEMSOLD01)
Check attcached file and Make utr month selections accodingly it will give you day comparisons
-Nagarjun
Hi,
Thanks for the post.
But need last year same day sales like i said
Today is Friday ,second week of march 3/10/2017 with this date sales i need to compare last year Friday ,second week of march 3/11/2016.
Thanks..
Try :
Sum({<Month,SoldDate, SoldYear={"$(=Year(Today())-1)"},
Month={"$(=Month(today()))"}, Week={"$(=Week(Today()))"},WeekDay={"$(=Weekday(Today()))"}>}ITEMSOLD01)