Forum Discussion
Dynamic measure for Overall return
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