Year Reference in Member Formula
Summary:
Would like to make this formula dynamic
Content (please ensure you mask any confidential information):
I have an account with a member formula that rerefnces the fiscal year. The current code (below) is hard coded. How can I make it dynamic so I don't have to change the years as we plan further out?
Version (include the version you are using, if applicable):
NSPB 24.06.86
Code Snippet (add any code snippets that support your topic, if applicable):
IF (@ISMBR(FY20))
2020;
ELSEIF (@ISMBR(FY21))
2021;
ELSEIF (@ISMBR(FY22))
2022;
ELSEIF (@ISMBR(FY23))
2023;
ELSEIF (@ISMBR(FY24))
2024;
ELSEIF (@ISMBR(FY25))
2025;ENDIF
0