nested aggregation not allowed

[saichawan]

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.

[saichawan]

do you want me to share the samle excel file ?

[sunny_talwar]

Sure

[saichawan]

fyi

[sunny_talwar]

But where is the calculation that gave you in Excel 121.23?

[saichawan]

FYI

[sunny_talwar]

When I sum (RTL_QTY), i get 3,731,149... how are you getting 4,346,295

[sunny_talwar]

and what is count of datee? I didn't see any row named datee?