Help with rule

      Help with rule

      I have a dimension "Name"

      The dimension elements are:
      1. All Name
      a. A
      b. B
      c. C
      d. D
      2. No Name

      I need a rule which sets No Name = 1, if All Name > 0, otherwise No Name = 0

      ['No Name'] = IF(['All Name']>0, 1, 0] doesnt work.. What am I doing wrong.


      This also does not work
      ['No Name'] = IF(['All Name']>0, ['No Name']=1,['No Name']= 0]


      Can you kindly provide the proper rule?

      rtindru wrote:


      ['No Name'] = IF(['All Name']>0, 1, 0] doesnt work.. What am I doing wrong.


      it should be a round parenthesis in the end : ")"

      rtindru wrote:


      This also does not work
      ['No Name'] = IF(['All Name']>0, ['No Name']=1,['No Name']= 0]


      you cannot use an element in the target and in the source. you have to use a second element for that

      hope that helps!
      laloune

      Post hoc, non est propter hoc