Need to calculate rate of sale

[saichawan]

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

[Taoufiq_Zarra]

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?

[saichawan]

it is a year, attaching you the data for your refrence