I am designing a FR report where i need to derive Quarters based on the User prompt.

Summary:

I am designing a FR report where i need to derive Quarters based on the User prompt. I am using function: Relative to Prompt for AccountingPeriod offset.

Business need is to restrict this Offset rolling till end of current year. Example: if User selects Jun-23, accounting member QTD should be derived for only two quarters, i,e Qtr1 -23 and Qtr2-23 but it should not roll into previous Qtrs.

If user selects Dec-23, all four quarters Qtr1-23, Qtr2-23, Qtr3-23 and Qtr4-23 should be derived in FR report.

Content (please ensure you mask any confidential information):