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

    Average Weekly for Specific Year

    Ashley Kuttler


      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.