Support formula wildcard characters so that formulas dont need to be constantly updated

Would like to be able to use wildcard characters in anaplan formulas, specifically in the SELECT function.

Ie. I have this:

IF Version Selection.Selection[SELECT: VERSIONS.'2018 Actuals'] THEN "SBUDGET"

I'd like something like this
IF Version Selection.Selection[SELECT: VERSIONS.'???? Actuals'] THEN "SBUDGET" where ???? can be any year and so that the formula doesn't have to be updated every year.

Comments

Miran

Status changed to: New

RobinOneHive

The support of wildcards in Anaplan would be quite useful, +1.

Dikshant

@luvazquez,

Use Lookup instead, a line item and a no-dimension module and then configure it using FINDITEM

Formulla: FINDITEM(Versions, "Budget" & NoDimensionModule.Year)

Let me know if a detailed explanation is required.

Quick Links

New ideas

Calendar Weeks in UX date fields
If you select a date in the UX it would be helpful to display the calendar week to the left of it, like in Microsoft Outlook.
Assistance Required for Understanding User License Roles at Tenant Level - Anaplan
Team - As per my understanding, user roles should work as described in the table below, but it is not working as expected. Our expectation is to assign users to a read-only role to restrict their access to a specific model, instead of creating user roles within the model. Any insights would be greatly appreciated. Thank…
Text input on total level
Dears, We would like you to enable text input on text summaries. Could you please consider adding “text input” button for text type summary method? This will help a lot for better navigation, for example when commenting data on total level like P&L total figures.