Forum Discussion
Solved
Compare this year vs last year based on two dates
Hello, I'm creating a reservation report for a hotel. I need to calculate the room nights, revenue etc, and compare this year to last year. The problem is with last year. I need to only sum the d...
Hi stampgeorge ,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Thank you
DataVitalizer
Super User
Super UserHi stampgeorge
Are you willing to hardcode the date to achieve your goal, so I can adapt my suggestion accordingly?
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge