Lumira 2 Discovery, formula for restricted misures not allowed ?

[Former Member]

Hi all, I've just installed Lumira 2, and I'm trying to create a formula like "IF {Year} = "2017" then {Sales Revenue} else 0", but it seems that in the formula editor for measure I should use only measure (the editor give me a message error).

I use the same syntax used on Lumira 1.x.

Any idea ?

Thanks.

MAX

[Former Member]

Simply is not possible because {Year} is a Dimension, and when I try to create a new calculation of type Measures, I've can only use other measures. I need to create a restriction based on a dimension value, and that seems to be not allowed.

Thanks.

MAX

[former_member183750]

What is the error?

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

SAP is now offering chat support. For more details please see KBA2213344 - How to start a chat with SAP Support[video]

Follow me on Twitter:https://twitter.com/crnanalysistips