3 Replies Latest reply: Dec 11, 2012 2:35 AM by sujeet singh RSS

    Using a variable to calculate an expression, and then reference calculated expression

      Hi

      I have a model I've been working on where I have made use of a variable to calculate the expression, based on the line item of the Dimension, so for e.g. I have a nested if statement in the variable and it would check (for e.g.) if Dimension line item = x, execute the following code, if Dimension line item = y, execute the following, etc. This has been working great thus far, but I now need to reference a specific line item value, for e.g. if Dimension line item = a, line item x + y - how can I reference the values in these cells...?