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

Visit Redwood Community
@prior not executing as expected — 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

@prior not executing as expected

Accepted answer
22
Views
6
Comments

Summary:

@prior not executing as expected, need to get the value 12 months back from the current month which im calculating.

Content (required):

Hi

Im using @prior to get the value before 12 months from the current period/month. Following is my rule.

when i launch this no value appears for me, even though there are values 12 months back in the system.


Please help.



"OFS_Calculated"

(

IF("Calculation Basis"->"BegBalance"->"No Year"->"Total Product"->"All Branch"==1)

"OFS_Calculated" = /*("Load Total"->&LastYr1->"OEP_Actual"-> "Working_PTD"->&LastPer1);*/

(@prior("Load Total"->"OEP_Actual"-> "Working_PTD",12,@xrange(&Lastyr1->&Lastper1,&Lastyr12->&Lastper12)));

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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