Forum Discussion
Same Period Last Year for two field
Hi all, I'm having trouble with the following. With the Snapshot date being exactly one year apart, I want to compare 2020 data with 2019 intake year data. As an example, 28,926 vs 24,320 ...
Ashish_Mathur
Super User
Super UserHi,
Could you share data in a format that can be pasted in an MS Excel file and also describe the question. What is snapshot date? Please also show the expected result.
Sure.
Snapshot date is the time the information was entered into our database.
Please refer to the table below for the excel format.
| Snapshot Date | 2019 | Expected Result | 2020 |
| 31/12/2019 | 28,926 | 24,320 | 19,549 |
| 31/12/2020 | - | 24,320 | |
| 17/06/2021 | - | - | |
| 5/08/2021 | - | - | |
| 31/12/2021 | - | - | |
| 17/06/2022 | - | - |
What I need is the expected result column.
Please be aware that Snapshot date and Intake Year are two separate fields that originate from the same table.