Average Weekly for Specific Year

[akuttler]

Hello,

I keep getting an error for the expression:

(Sum({<ITEMTYPE={'C'},Year={2017}>}Trans))/(Count(Distinct DATE({<Year={2017}>}WeekYear)))

Fields names ITEMTYPE= 'C' refers to Charges

Trans =Transactions

I am trying to get the Average Weekly Charges for 2017.

Thanks in advance.

[OmarBenSalem]

what is this DATE doing here?

Count(Distinct DATE({<Year={2017}>}WeekYear)