Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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]))
See the attached file