I have 2 fields that I need to compare in a table, the first "R1" is recorded every day. The second "R2", only some days of the month. Something like that:
Fecha
R1
R2
01/11/2017
3
02/11/2017
4
03/11/2017
3
10
04/11/2017
3
05/11/2017
4
06/11/2017
3
10
07/11/2017
4
08/11/2017
4
Suma real
28
20
Suma QV
6
20
My problem is that when adding each field [with a Sum (Total <Month> R1)], it gives me as a result the sum of the days in which both records were taken. [That is, in the example it would only take the days 03/11 and 06/11 and it would give me as a result R1 = 6 and R2 = 20]
I need the formula to get the real sum of R1 (28) and be able to calculate R2 / R1 on a weekly basis
