@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
... View more
