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.
