Skip to Content
0

Lumira 2 Discovery, formula for restricted misures not allowed ?

Aug 22, 2017 at 02:53 PM

124

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ludek Uher
Aug 24, 2017 at 07:34 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 25, 2017 at 12:27 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded