Nested Functions in Narrative Reporting Not Returning Data

Summary:

Nested function in Relative Member does not return values.

Content (please ensure you mask any confidential information):

Hi there, I'm creating a report in Narrative Reporting that is connected to Oracle ERP GL database. I have Accounting Period (year → quarter → period) in the columns and want to create two data columns: one pulls all periods in the POV year and one pulls all periods in the year prior to the POV year. I'm able to create the first column successfully using Bottom Members of CurrentPOV function. However, the second column returns no data when I use Bottom Members of Relative Member of CurrentPOV -1