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

# Current Month Average Daily Charges

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.

• ###### Re: Current Month Average Daily Charges

Ashley,

I guess you must to change your expression a little bit:

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

• ###### Re: Current Month Average Daily Charges

Thanks, I realized I would also have to apply the set modifier to the denominator so :

Current Month Average Daily Charges:

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