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

       

       

       

       

      Thanks

      B