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