The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Variables
Good Morning! Does anyone know how to build upon the set up variables in OneStream?
For Example: |CVYearNext| - This gives me the following year of the CV. What if I want the following Year and...
Hi mbahena,
For flexibility and reuse, I would use an XFBR for this requirement that takes two arguments, the current year, and an integer to add to that year, e.g. 2 for currentyear + 2 to get two years ahead, or -3 for currentYear + -3 to get third year prior.
I would recommend to explore the Member Filter Builder, there are plenty of examples on how to use built-in functions regarding time.
XFBRs give the ultimate flexibility when all these built-ins fall short, but the best option is always to reach for prebuilt functionality if available - it's easier and requires less maintenance than any custom code-based solution.
Hi mbahena,
For flexibility and reuse, I would use an XFBR for this requirement that takes two arguments, the current year, and an integer to add to that year, e.g. 2 for currentyear + 2 to get two years ahead, or -3 for currentYear + -3 to get third year prior.
Awesome, thanks for the feedback. Would you have an example for an XFBR function? I never used it before. Thanks in advance, your help is greatly appreciate it.
