Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
FRS - Does RelativeMember Function work on Prompted AccountingPeriod? — Cloud Customer Connect
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

FRS - Does RelativeMember Function work on Prompted AccountingPeriod?

Accepted answer
15
Views
4
Comments
edited Apr 2, 2020 9:20PM in Reporting and Analytics for ERP 4 comments

Summary

FRS - Issue with period-to-period comparison on prompted values

Content

I am creating a Period-to-Period Financial comparison report, where Accounting Period needs to be prompted. Accounting Period appears in the column of the dimension layout, say at Column A where the value is prompted. At column B, I tried to apply the function "Relative to Same as Col A offset by -12". But at run time, it is not calculating the offset - so if I select Accounting Period parameter to Apr-20 period, both column A and B come up with Apr-20 whereas the expectation was to have Apr-20 vs Apr-19.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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