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?
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?