This content has been marked as final. Show 3 replies
I'm creating a calculated dimension in the script editor
Let say I have a field called RateVale with the values A,B,C,D,null()
I want to create a calculated field called Picked with 2 values in it Yes and NO based on the following condions
if RateVale =A,B or Null() then Picked is Yes else 'NO'
I'm tryinng something like
if(match (RateVal,'','',null()),'Yes','No') as Picked
will the above code work?I'm not sure if it will pcik nulls,should I use len(trim(Ratevale)) instead of null()