Day to day comparision

[nareshthavidishetty]

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..

[muthukumar77]

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)

[nagarjuna_kotha]

Check attcached file and Make utr month selections accodingly it will give you day comparisons

-Nagarjun

[nareshthavidishetty]

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..

[tresesco]

Try :

Sum({<Month,SoldDate, SoldYear={"$(=Year(Today())-1)"},

  Month={"$(=Month(today()))"}, Week={"$(=Week(Today()))"},WeekDay={"$(=Weekday(Today()))"}>}ITEMSOLD01)