14 Replies Latest reply: May 16, 2018 3:28 AM by bhasker kumar RSS

    Filter pane dimension

    Joshua Solomon

      Dear all,

       

      I have a field called Abnormal which has the data 'H','L',' '

      Now i want to drive a field called Normality based on the condition

      1.if Abnormal is 'H','L' then the data should be 'Abnormal'

      2.if Abnormal is ' ' then the data should be 'Normal'

       

      Expected output:

      Normailty

      Abnormal

      Normal

       

      I used this if(subfield(Abnormal,',')='','Normal','Abnormal' ) as Normality but i am getting some null values also  in Normality field.

       

       

      Regards,

      Joshua.