Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I trying to calculate the rolling and ytd revenue for current and last year revenue, but not from the month of january to december. i need to do it from Sep 2017 to Aug 2018 and sep 2018 to Aug 2019.
='Current Year:'& Num(Sum({<[Trading Week End Date] = {">=$(=MakeDate(Year(Today()),9,1) )<=$(=MakeDate(Year(Today())+1,8,30) )"}> } NET_SLS_AMT/1000000),'##.00')
& ' Last Year:'&Num(Sum({<[Trading Week End Date] = {">=$(=MakeDate(Year(Today())-1,9,1) )<=$(=MakeDate(Year(Today()),8,30) )"}> } NET_SLS_AMT/1000000),'##.00')
I'm using this formula, but sales is reflecting from january to december. Can you please help me with this problem to get rolling & ytd sales from july month to june month
Thanks
here you compare [Trading Week End Date] which is a year with a full date?
Can we change [Trading Week End Date] by week?
Sep 2017 to Aug 2018 and sep 2018 to Aug 2019
or
Sep lasyear(2018) to Aug this year (2019) ?