1 Reply Latest reply: Dec 8, 2017 11:18 AM by omar bensalem RSS

    Average Weekly for Specific Year

    Ashley Kuttler

      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.