report collects the data of a month as the sum of the rest of months

[snavas]

Hello, I hope to express myself well to show you my problem.
I have a report that collects sales for the years 2021, 2020, 2019, 2018 and 2017 but for 2020 filtering by months, the December sum is equal to the sum from January to November.
Is it a common mistake? I have checked the script many times and I do not see any errors, besides that for the rest of the years the data comes out fine.

Thanks for your help.

[Or]

This sounds more like an issue with your underlying data than anything to do with Qlik, but if you provide a more specific formula / example app, perhaps it would be possible to investigate.

[snavas]

the formula is similar to this:

---

Sales:

LOAD [SalesTotal]

Sales2020:

LOAD 

[SalesTotal] as [SalesTotal20]

Resident Sales where [DateYear]=2020;

----

for the rest of the years it is the same formula.

thanks for your help

[Or]

There's nothing about this formula that suggests it would return incorrect values, so I would check the underlying data.

[snavas]

Yes, the formula worked correctly for the other years.

I´ ll keep looking for the error, thank you very much.