3 Replies Latest reply: Sep 20, 2013 3:44 AM by Saumya Shah RSS

    Null value in set analysis

    Saumya Shah

      Suppose i have blank values in one of the field. how will i calculate it considering it?

       

      For Example : in

       

      FieldA

      FieldB

      1a
      2b
      3
      4d
      5


      i want to calculate count of number whose fieldB value is b,d and null

      i did   Count(Distinct {<[FieldB]={'b','d',''}>}[FiledA])

      and i get output as 2

       

      i want  output as 4