Skip to main content
Newcomer
July 1, 2024
Solved

T#YearPrior1(|WFTime|) Question

  • July 1, 2024
  • 1 reply
  • 0 views

I can use T#YearPrior1(|WFTime|) in my cube views and it yields the correct date. However, when I use this variable in my ConfirmationRuleArgs, I get an error noting: "Invalid calculation script. Unexpected text. |WFTime|)."

Is there a way to have the confirmation rule pull December PY based on the workflow time the user is in? 

Thanks for the help!

Best answer by T_Kress

If you have access to GolfStream, there are several confirmation rule examples in there which deal with both WF time and Prior year time.  Here is one example:

T_Kress_0-1719864485862.png

That should help get you started in the right direction.

1 reply

T_Kress
OneStream Employee
T_KressOneStream EmployeeAnswer
OneStream Employee
July 1, 2024

If you have access to GolfStream, there are several confirmation rule examples in there which deal with both WF time and Prior year time.  Here is one example:

T_Kress_0-1719864485862.png

That should help get you started in the right direction.

AHaslettAuthor
Newcomer
July 2, 2024

Thanks so much!