Null value in set analysis

[saumyashah90]

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

For Example : in

FieldA	FieldB
1	a
2	b
3
4	d
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

[#2]

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)

[er_mohit]

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

[er_mohit]

See the attached file