Skip to Content
avatar image
Former Member

Lumira 2 Discovery, formula for restricted misures not allowed ?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 24, 2017 at 07:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 25, 2017 at 12:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded