Hello!
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
