I have a sub-summary report that lists phone numbers and frequency of the phone numbers in a report. Some records do not have phone numbers and many records use the same phone number. Is there a way where when I run this report I can count the unique times a phone number is used?

The summaries on the report at the bottom account for how many numbers make up the report and not how many unique numbers there are.

Likewise I would like to know how to count the number of projects built by phone number. I am using a table occurrence to show related phone number and a calculation field that counts these occurrences. However I cannot figure out how to count the projects in this report.

Any help would be greatly appreciated.

Affordable_Housing_2.fp7.zip

Phone_Number.pdf

Edited March 1, 200817 yr by Guest

Hi

I've added three new fields; 'Primary_Key', 'Count_Tel' & 'Total_Count_Tel'.

I've then placed the last field, which is a summary, on your report. Think this delivers what your looking for.

Cheers

Paul

Affordable_Housing_2.fp7.zip

Thanks Paul for your post. You lead me in the right direction and I was able to figure out how FM could do a unique record count like in SQL although not as easy.

While Paul is perfectly syncronized with Ryan Rosenbergs way of reasoning, shouldn't it be ignored the vast number of indexed fields it produces, it's not normalized too well in my humble opinion, hence my calling it a giant on clayfeet:

http://fmforums.com/forum/showtopic.php?tid/189946/post/266469/hl/clayfeet/fromsearch/1/#266469

The types and data needs to get broken out in a new table!! But I gladly listen to arguments against it???

--sd