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

Options
shashishankar
shashishankar Member, ALL USERS, Partner Posts: 5 Contributor

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

  • shashishankar
    shashishankar Member, ALL USERS, Partner Posts: 5 Contributor

    Hey David,

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