Report Glitch?

DA_Associates_PM

Has anyone ever seen a glitch with a report? Maybe its user error lol.

I have a report with the following filters

However, for some reason it is pulling a line with an end date in March. There is also a sooner date in January that it is not picking up (I wouldn't expect it to since its not in the next 14 days).

Any thoughts why it would be pulling this line into the sheet?

Dale Murphy

@DA_Associates_PM Not sure I see the issue. You do have an OR clause in your filter that allows end dates in the past, and March 2021 is in the past. So, depending on your definition of Milestone and depending on which status conditions you allow, it isn't unreasonable to see this item.

dm

DA_Associates_PM

@Dale Murphy Thank you so much. I'm a dope. So it was user error lol. Thank you again!!!

Dale Murphy

@DA_Associates_PM Haha, we all the challenge of binary logic!

Your query caught my attention because I am waiting for an answer about an apparent reporting bug. A report does not show all the expected rows but still calculates a group total properly. Had my users scratching their heads.

So reporting has a few foibles.

Cheers,

dm