Retrieve past element entry amount in comp plan through Fast Formula

Summary

Retrieve element entry amount in comp plan at a certain date

Content

Hello,

in my annual comp plan, I need to pull data from a certain element entry amount in 3 different columns through fast formula:

Ex:

- Element entry amount (current year) --> 2000£  (this has 01/01/2019 as start date and as end date)

- Element entry amount (year-1) --> 3000£ (this has 22/04/2018 as start date and as end date)

- Element entry amount (year-2) --> 4000£ (this has 01/12/2017 as start date and as end date)

 

I set up this FF for the case YEAR-1 but it retrieves me always the current entry amount (2000£). How can I achieve this?