Hi Everyone,
My report contains many columns. Like below
I have a year filter. I am trying to calculate the previous year value
To calculate the previous year value I used the below formula
and it skips the first value
Can anyone help me fix this? I checked multiple solutions on the forum but it doesn't align with my entire report. It requires to create a parameter.
Your help is appreciated.
Thanks,
Krish.
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.
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.