SELECT command does not work with Version name having number in its name

Hi,

I was working to find products ASP for a Version with a variance of 10% between product ASP in other Version. For example, product ASP outlier with version BOQ(Beginning of Quarter) works well unlike EOQ1 (It consists of text and number). 1st formula works well unlike the 2nd one which gives Inval. I believe its a bug in SELECT command for Version where it accepts only text character in Version name. Can you please assist for a solution.

1. IF Net ASP < 0.1 * Net ASP[SELECT: VERSIONS.BOQ] THEN 1 ELSE IF Net ASP > 1.1 * Net ASP[SELECT: VERSIONS.BOQ] THEN 1 ELSE 0

2. IF Net ASP < 0.1 * Net ASP[SELECT: VERSIONS.EOQ1] THEN 1 ELSE IF Net ASP > 1.1 * Net ASP[SELECT: VERSIONS.EOQ1] THEN 1 ELSE 0

Comments

Miran

Status changed to: New

DavidSmith

@shashishankar

Just to say, this is possible - When Anaplan elements contain special characters, such as numbers, one needs to enclose the element with 's

This automatically happens with most elements when you click on them as part of the formula editing, but as you can't do this for Versions, you will need to manually do this. So your formula should be

IF Net ASP < 0.1 * Net ASP[SELECT: VERSIONS.'EOQ1'] THEN 1 ELSE IF Net ASP > 1.1 * Net ASP[SELECT: VERSIONS.'EOQ1'] THEN 1 ELSE 0

I would also add that from a best practice perspective it would be better to split the line items and use booleans as a result if possible. The calculation of Net ASP[SELECT: VERSIONS.'EOQ1'], can then be calculated independently and a boolean result is more efficient and takes up less space than a number. So the formulas would be:

line item 1 = Net ASP[SELECT: VERSIONS.'EOQ1']

line item 2 = Net ASP < 0.1 * line item 1 OR Net ASP > 1.1 * line item 1

Hope this helps

David

shashishankar

Hey David,

Thanks for your quick response. I couldn't recall for a while that number would also be treated as a special character.

DavidSmith

No worries - If you were able to click on the version item, it would have put the ' in automatically!

Quick Links

New ideas

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.
Ability to Generate Management Reports based on a Hierarchy Chart
We currently have a requirement, working with a very large Bank on their Workforce planning use-case to view their Organisational Hierarchy in a Current and Proposed state. The UX view of the Hierarchy Chart works well, even with very large volumes of data. There is also a requirement to have a Management Report that…