how to calculate average per day/month

MEDHA07 — Wed, 29 Sep 2021 16:55:14 GMT

Hi All,

I need to calculate the 3 measures .

first measure perday total records count

Second measure Average per day

Third measure Total average on month

below is my data set:

how to show each date today records+previoustotalrecordscount?

how to calculate dynamically subtracting each day’s results from the previous day’s results by category.today records minus previous daytotalrecords.

adding each day’s “Per Day” count to the previous results and dividing by the number of days in the month

11/30/2020	3493912		Avg/day/Month
12/1/2021	3495298
Per Day	1,386	1,386
Avg/Day/Mo	1,386		1386/1
12/2/2021	3,503,457
Per Day	8,159	8159	1386+8159/2
Avg/Day/Mo	4,773
12/3/2021	3,509,552
Per Day	6,095	6095	1386+8159+6095/3
Avg/Day/Mo	5,213
12/4/2021	3,509,552
Per Day	0	0	1386+8159+6095/4
Avg/Day/Mo	3,910
12/5/2021	3,509,552
Per Day	0	0	1386+8159+6095/5
Avg/Day/Mo	3,128
12/6/2021	3,521,631
Per Day	12,079	12709	1386+8159+6095/6
Avg/Day/Mo	4,620
12/7/2021	3,524,264	28,349	total/30 days
		Total average per day

Re: how to calculate average per day/month

abhijitnalekar — Thu, 30 Sep 2021 13:40:32 GMT

Hi @MEDHA07 ,

Please use this formula.

rangesum(above(
num(Sum({$ <InvoiceDate={"$(='>=' & Date(MonthStart(Max(InvoiceDate)), 'MM/DD/YYYY') & '<=' & Date(MonthEnd(Max(InvoiceDate)), 'MM/DD/YYYY'))"}>}
sale),vCurr),0,RowNo()
))/max(day(InvoiceDate))

topic how to calculate average per day/month in App Development

how to calculate average per day/month

Re: how to calculate average per day/month