Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!