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

# Null value in set analysis

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

• ###### Re: Null value in set analysis

try this

hi

your code is right, only the problem of null value these null value defined by two ways like this

suppose you have blank cell then try this

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

suppose you have blank value with space then write this

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

• ###### Re: Null value in set analysis

try this

Count({\$<[FieldB]={'b','d',''}>}[FieldA])

or this in text object to count null if it work then use another fields using wildmatch

Count(if([FieldB]='',[FieldA]))

for wildmatch try this

Count(if(wildmatch([FieldB],'b','d',''),[FieldA]))

• ###### Re: Null value in set analysis

See the attached file