0 Replies Latest reply: Apr 18, 2017 10:47 AM by clark meyers RSS

    Variables and Flags

    clark meyers

      Hello,

       

      I want to exclude some types of my calculated measure.

       

      So I need to define a flag. My approach was to define a variable in the UI.

       

      vFlag: if( TYPE='A', 1,0)

       

      Then I created a master element Using this Formula (and lots of variations):

       

      mRevenue:

      Sum(If(($(vFlag),REVENUE,0)))


      Sum(If(($(vFlag)=1,REVENUE,0)))

       

      There is no syntax error. No results.

       

      What's wrong here ?

       

      And what are your experiences with the handling of measures in the UI ?

       

      Thanks in advance!