How to calculate total of function (data from yesterday-data from today)

[Karolina1]

Hi guys, 

I have dates, A data and B data in excel file. I would like to move them into Qlik and calculate C data based on A and B . 

Dates	A	B	C - calculated using a formula in Qlik	C - explanation
25.06.2023	680	20	-	-
26.06.2023	540	13	153	=B2-B3+C3
27.06.2023	520	14	34	=B3-B4+C4
28.06.2023	674	10	-144	=B4-B5+C5
29.06.2023	700	7	-19	=B5-B6+C6
30.06.2023	530	15	185	=B6-B7+C7
Total	=AVERAGE(B2:B7)	=SUM(C2:C7)	209	=SUM(D2:D7)

My issue appeard in the total of the June for C data. Do you have any idea how to calculate summary of the June in Qlik?