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

How to change Dimension Year in Forms in previous month January situations?

Summary:

I like to build a simple form with two columns current month and previous month.

How to adjust the year dimension based on the Period Dimension Member January.


Content (required):

I like to build a simple form with two columns current month and previous month.


At first a used Function Relativ Current Month -1 which works well for the Dimension Period.

However, I cannot figure out a way to have the year change when current month is January -> Previous month is December but also the previous year.


How to adjust the year dimension based on the Period Dimension Member January.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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