Formula to measure coverage

[johndemars]

Hi,

I'm trying to get a formula to measure the coverage of my account portfolio. 

For example:

Account	number of visits
Account A	5
Account B	1
Account C	3
Account D	0

So the coverage will be 75% because 3 of the 4 accounts has a minimum of 1 visits.

Tnx

John

[GaryGiles]

If [number of visits] is a field in your table, you could use:

count({$<[number of visits]={">0"}>} Distinct Account) / count(Distinct Account)

If the table has a unique row for each visit and the visit field contains 1, you could use somthing like:

count({$<Account={"=sum(visit)>0"}>} Distinct Account) / count(Distinct Account)

[johndemars]

Hi Gary,

The data is in two tables associated on Account.