4 Replies Latest reply: Jan 10, 2017 8:39 AM by Kyle Roberts RSS

    Average Charges Per Day

    Kyle Roberts

      I am trying to calculate average charges per day of the month. So for example I need to look back 12 months to get the average charges on each day. On the 1st, I need to calculate the average charges for the previous 11 months on the 1st. I need to do that every day. I need that to be rolling for the month. Meaning, If the average on the 1st of the month is $3,000 and the average of day 2 is $4,000. I need day 2 to show $7,000.

       

      This is how charges are calculated....   Sum({$<[DETAIL_TYPE] = {1,10}>}AMOUNT)