4 Replies Latest reply: May 13, 2011 9:11 AM by Paul Nockolds

# Displaying count of blank Emails

I was wondering if anyway could suggest the best way to display this...

I have a list of email addresses (see below).  Anyone who does not have an email address has <Not Answered> as their email address.

I need to be able to display the total number of people with an email address and also the total number of people who do NOT have an email address (i.e. <Not Answered>)

Any ideas how best to go about calculating and displaying this would be greatly appreciated.

• ###### Displaying count of blank Emails

Exemple

In the script

Then in your graphs , you sum the two values.

Philippe

• ###### Re: Displaying count of blank Emails

That does help me isolate and total them up. In fact i adopted your idea here as i was forcing in the <Not Answered> to make it selectable

```Customer:
If(Len(Trim([Email Address])) = 0, 1, 0) as NoEmail,
If(Len(Trim([Email Address])) <> 0, 1, 0) as EmailExists,
FROM
CDSLayout.xls
(biff, embedded labels, table is [acs layout\$]);
```

So i can now show the totals in a Statistics box but i would like them to be able to select one of the totals so they can filter the data down to show all the people with or without an email address.

Sadly a statistic box does not appear to be selectable

Any ideas?

• ###### Re: Displaying count of blank Emails

HI, Paul

If you want to use it to make selection you could merge the fields  EmailExists and NoExists in a single one

```Customer:
If(Len(Trim([Email Address])) = 0, 1, 0) as NoEmail,
If(Len(Trim([Email Address])) <> 0, 1, 0) as EmailExists,
If(Len(Trim([Email Address])) <> 0, 'Exists', 'NoEmail') as Existence,

FROM
CDSLayout.xls
(biff, embedded labels, table is [acs layout\$]);

```

Regards,

Erich

• ###### Re: Displaying count of blank Emails

Brilliant - thanks Erich that's perfect