3 Replies Latest reply: Jul 18, 2018 5:08 PM by Thiago Justen Teixeira RSS

    Current Month Average Daily Charges

    Ashley Kuttler

      Hello,

       

      I am trying to write an expression that gives me average daily charges:

       

       

      (Sum({<ITEMTYPE={'1000','1001'}, Date = {"$(=Max(Month(Date)))"}>}Trans)) / (Count(Distinct [Service Date]))

       

      Where ITEMTYPE = 1000,1001 represents charge transactions

       

      I've tried several things but they all give me zero or null.

       

      Thanks in advance.