-
1. Re: Previous year calculation
Hari Ankem Jun 11, 2018 3:29 PM (in response to Krishna Dudhela)Please attach your packaged workbook.
-
2. Re: Previous year calculation
Krishna Dudhela Jun 11, 2018 4:38 PM (in response to Hari Ankem)Hi Hari,
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.
Thanks,
Krish.
-
Previous_year.twbx 60.4 KB
-
-
3. Re: Previous year calculation
Bryce Larsen Jun 12, 2018 11:12 AM (in response to Krishna Dudhela)Any chance you can save this down to 10.3?
-
4. Re: Previous year calculation
Krishna Dudhela Jun 12, 2018 11:14 AM (in response to Bryce Larsen)It's already upgraded to v 10.5. So it won't open in 10.3. Unfortunately
-
5. Re: Previous year calculation
Bryce Larsen Jun 12, 2018 11:16 AM (in response to Krishna Dudhela)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?
-
6. Re: Previous year calculation
Hari Ankem Jun 12, 2018 12:32 PM (in response to Krishna Dudhela)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.