Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
1) ARe you trying to add this as Dimension or MEasure?
2) Can one ClientCode have more than one ECSSettingsNumber ?