Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need a urgent help on this. i need to find rate of sale, the number of units sold pe week for current and previous year. below is the formula i'm using.
='Current Year:'&Num( Sum({<[Trading Week End Date] = {'$(=Year(Today()))'}>} (RTL_QTY) /Count(date)),'##.00')&
' Last Year:'&Num(Sum({<[Trading Week End Date] = {'$(=Year(Today())-1)'}>} (RTL_QTY) /Count(date)),'##.00')
can you please help with the solution.
do you want me to share the samle excel file ?
Sure
fyi
But where is the calculation that gave you in Excel 121.23?
FYI
When I sum (RTL_QTY), i get 3,731,149... how are you getting 4,346,295
and what is count of datee? I didn't see any row named datee?