Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to calculate rate of sale for rolling and ytd period. rate of sale is the number of units sold per week.
ros=retail_quantity/count(distinct week)
='Current Year:' & Num(Sum({<[Trading Week End Date] = {'$(=Year(Today()))'}>} RTL_QTY)/Count(DISTINCT( week)), '##.00')
&
' Last Year:' & Num(Sum({<[Trading Week End Date] = {'$(=Year(Today())-1)'}>} RTL_QTY)/Count(DISTINCT( week)), '##.00')
I'm trying this formula, but it is not working out. Can you please help me out on this
Thanks
Sai
Hi,
just a remark, can you confirm that,
in the formula:
[Trading Week End Date] = {'$(=Year(Today()))'}
do you compare years?
[Trading Week End Date] is it a year? not a full date?
it is a year, attaching you the data for your refrence