Expression does not allow static text, but allows field values

[JamesMF82]

I've got a very strange problem at the moment. I have the following formula

=if(isNull(ClientCode),
      if(IsNull(ECSSettingsNumber), 'Activity','Setting')
          ,'Client')

and then the first two checks are positive it does not show Activity and shows '-' instead (Though the Setting and Client text come through fine)

However if I change it to a field, it works fine. I've tried using concat or a variable and it's not working. Very strange.

=if(isNull(ClientCode),
      if(IsNull(ECSSettingsNumber), EventCode,'Setting')
       ,'Client')

Any help would be great.

[vinieme12]

1) ARe you trying to add this as Dimension or MEasure?

2) Can one ClientCode  have more than one ECSSettingsNumber  ?