Forum Discussion
Dynamic measure for Overall return
I just noticed that the "end date" was supposed to be 31/07/2020 while the "years remaining (from beginning")" is correctly set at 3 years - sorry!
As a result of this and the fact mentioned in the initial scope that the years remaining "must increase by 1 everytime there is one year difference between the selected "End date" (31-07-2020 in this example) and the date of return" (all the dates listed in the mid table explaining how the data is worked with).
This means that it changes to 4 years when the date reaches "31/07/2019" as shown in your "following dates" and 5 years from "31/07/2018"
Is it more clear now?
Super UserHi Anonymous ,
Just one additional question what happens to the selection of dates if you for example slect the years remaing as 4 or as 2?
Can you share the expected result on the data selection?
I already have the values changing accordingly but I need to understand what happens becuase currently I'm stuck at 3 4 and 5 yearsa based on the date selected.
Hi MFelix
Changing the number of years remaining will not influence the selection of dates.
Does that make sense?
Anton
- MFelix
Hi Anonymous ,
Yes it make sense. So you are saying that if I select the exact same data but with 4 years instead of 3 the data selection is the same except my calculation is made only on the rows with 4 and 5 years is that it?
Hi MFelix
By keeping the dates the same while selecting 4 years instead of 3 for the "years remaining" it should do the same calculations, yes but instead selecting only the data points where this is correct, so start out with 4 years (instead of 3 in the example), then change to 5 years (from where it says 4 today) and continue to take 6 years for the last rows (where it is 5) in this example. So changing the beginning value of "years reamaining" will affect all the data that the model should select and calculate it for.
Hope that makes sense
Anton