Run you're report for all patient - not just those with an email address. Then I suggest using a formula to set up your email count. It will look something like this:
{@ValidEmail}
If InStr(LowerCase({table.email}), '.com') > 0 or
InStr(LowerCase({table.email}), '.net') > 0 or
InStr(LowerCase({table.email}), '.edu') > 0 or
InStr(LowerCase({table.email}), '.gov') > 0 then
1
else
0
In your report, you'll do a sum of this formula to get the count of patients with an email address. To get the percentage, you'll use a formula like this:
sum(
{@ValidEmail}) % count({<however you're counting patients})
To automatically display the '%', format the number, turn on the "Currency Symbol", set the position to be after the number and change the symbol to '%'.
-Dell
IP Logged
