Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...?
Please post a sample and such imlementations are only possible with set Analysis
Can You Give me Some Data....
Go to following thred..u may get sm idea