Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
PBCS- How to create an Account dimension with Years members — 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

PBCS- How to create an Account dimension with Years members

Received Response
19
Views
4
Comments
edited Sep 6, 2021 4:20PM in Planning 4 comments

Summary

How to create an Account dimension for calculating prior year data

Content

Hi,

I need to know how to create an Account dimension that shows prior years data (such as Prices) starting from actual.

For example, with a IF function I'd like to show prices of 2021 or 2020. But the following statement retrieves only data from FY20, so there is something wrong in the first condition.

IF (@ismbr("FY22"))
"Prezzo_r"->&PrevYear->&PrevMonth;  
ELSE
"Prezzo_r"->FY20->Jul;
ENDIF;
 
 

Version

21.08.83
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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