Forum Discussion
Anonymous
7 years agoNot applicable
Weekday current year vs last year
HI Anonymous I have seen lots of posts, but i havent been able to implement this in my case. basically i want to do this functionality on monday, it should show fridays sales CY and frid...
v-juanli-msft
Community Support
7 years agoHi Anonymous
"
eg today (monday) 1/21/2019
DAILY Sales CY = , it should display last fridays sales i.e 1/18/2019 (3rd week friday )
DAILY SALES LY = (1/19/2018) (3rd week friday )
because sometimes we have sales on sat/sunday..
so i used lastprocessed (date) = returned 1/20/2019 but for sunday of last year ( 1/21/2018) there were no sales ..thereby getting blanks
"
Would you like to get MTD or YTD values?
for example ,
eg today (monday) 1/21/2019
DAILY Sales CY=values from 2019/1/1 to 2019/1/21
DAILY SALES LY =2018/1/1 to 2018/1/21
or you just want to get the values on one day?
Please clear me.
Best Regards
Maggie
Anonymous
7 years agoNot applicable
Just values of one day.
"Daily sales "