5 Replies Latest reply: May 14, 2018 1:03 PM by Ashley Kuttler RSS

    Average Daily Charge Most Recent 6 months

    Ashley Kuttler

      Hello,

       

      The following expression gives me average daily charges:

      (Sum({<ITEMTYPE={'C'}>}Trans)) / (Count(Distinct  ([Transaction Date])))

      How would I re-write it to give me average daily Charges only for the most current 6 months (transaction date)?