3 Replies Latest reply: Apr 28, 2016 10:26 AM by Pooja N RSS

    Flagging null or counting nulls for calculated dim

    Balraj Prabhu

      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()