How to get the Fiscal year budget balance based on accounting period prompt

Summary:

We have an FRS report requirement to display the fiscal year budget amount based on the accounting period prompt selected by the user.

We have a source budget with monthly calendar and we want the annual balance for the scenerio selected in the FRS.
For example, if the report is run for the accounting period Mar-2024, the column should display the budget amount for the complete fiscal year, that is Oct-2023 to Sep-2024.

Currently, we are unable to derive the fiscal year dynamically using available functions such as Parent or Ancestor, as they are not returning the expected fiscal year output.