Why Relative to Prompt for AccountingPeriod offset by -11 is working fine to get Previous year?
Summary:
FRS report - Doubt on Relative to Prompt for AccountingPeriod offset by -11
Content (please ensure you mask any confidential information):
I am running a report for 2025 year, but I am getting the data for 2025 and at the Previous year data I am getting 2021 instead of 2024, I have checked the function prompt as Relative to Prompt for AccountingPeriod offset by -14, but when I checked in the Period hierarchy and I can see there are two adjusting periods. Then I ran the report with Dec-25, then I am getting data properly as YTD for 25 & at PY 24. Now I have changed the prompt to -11, now if I run the report with 2025 year, I am getting same YTD data for 2025 and 2024. Here, I just want to know that why this -11 prompt is working properly. Additionally, If I changed to -12, the PY is 2023, for -13 the