Please attach your packaged workbook.
Attaching the sample workbook.
I have two worksheets.
1. Using LOOKUP:
----> I am losing the first value.
2. Using DATEDIFF
---> Value populates only for 2018. If we change the year then that column goes blank.
Previous_year.twbx 60.4 KB
Any chance you can save this down to 10.3?
It's already upgraded to v 10.5. So it won't open in 10.3. Unfortunately
Fair enough. Are you able to share excel file or anything?
And/or can you post screenshot of what the Table Calc is computing along?
I have been looking into this issue. The way you are doing lookup is incorrect and also the values you have are incorrect too. The values for previous year should get you the values from the same month in the prior year. Am I right?
You will need to join the data with itself, and then use LOD's to get the correct values for the current year and prior year. The data from the left side should get you the current year data, while the data from the right side should get you the prior year data.