Counting field values where another field is null

[ryanfoster84]

Hi,

i am counting the number of hashtags where the campaign field is blank and am using the following formula:

=count({1-<

[Campaign Name]={*}

>}[Hashtags])

this works fine and i am generating the top 10 (see below)

Hashtags	Total
	14300
CMED	71
NNLN	45
OptionsFocus	39
Ultra10	33
BZ	20
directoptions;OptionsFocus	19
agoptions	16
Treasuries	16
NNLN;OptionsFocus	13

the issue is i want the count to exclude also the blank hashtags and have tried using the table properties (Dimensions) to suppress the null values in hashtags field but this doesn't work. can anyone assist?

thanks

ryan

[sunny_talwar]

May be this:

=Count({1-<[Campaign Name]={*}, Hashtags = {"=Len(Trim(Hashtags)) > 0"}>}[Hashtags])

=Count({1-<[Campaign Name]={*}, Hashtags = {"=Len(Trim(Hashtags)) = 0"}>}[Hashtags])

[ryanfoster84]

Hi,

No this doesn't work it just count the total of each hashtags. basically the table above i don't want blanks include so the top ten will have values

Hashtags	Total
I WANT THIS REMOVED	14300
CMED	71
NNLN	45
OptionsFocus	39
Ultra10	33
BZ	20
directoptions;OptionsFocus	19
agoptions	16
Treasuries	16
NNLN;OptionsFocus	13