Trying to fetch the latest basic salary components in the compensation worksheets using fast formula
Summary
Our compenstion plan start date and end date is from 01-JAN-2024 to 31-DEC-2024(have attached the plan details below) , Here i am trying to fetch the latest basic salary of the employee in compensation worksheet which is effective from 01-jan-2025 , But the the Fast formula is fetching the the salary change only between 01-JAN-2024 - 31 -dec 2024.
Only for few employee we have a salary change post 01-jan-2025 .I need to fetch the latest salary.
If i change the plan end date 01-jan-2025 , i am able to fetch the latest base salary , How can i achieve this with out changing the plan end date?