Retrieve past element entry amount in comp plan through Fast Formula
Summary
Retrieve element entry amount in comp plan at a certain dateContent
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?
Tagged:
0