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

Prior Quarter Logic for First 3 months of Current Year Quarter 1

Accepted answer
22
Views
3
Comments

Summary:

Prior Quarter Logic for First 3 months of Current Year Quarter 1.

We are working on a Grid to show up in a Report Containing Value for

Current Month, Current Qtr, e.g: Feb, Q1, 2022

Prior Qtr, Prior Year, e.g Q4, 2021

Content (required):

We are able to settle down the Year value with relative function using offset and substitution variables.

But we need a solution for Prior Qtr.

Approach # 1,

Display all Q1, Q2, Q3, Q4 columns for prior year and hide Q1, Q2, Q3 and display Q4, when period is selected as Jan, Feb, Mar

For rest of the period, Relative function helps

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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