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

    Current Month Average Daily Charges

    Ashley Kuttler



      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.