AnsweredAssumed Answered

Counting Related Records

Question asked by sccardais on Mar 21, 2016
Latest reply on Mar 23, 2016 by erolst

I want to create a report that includes a count of related records.

 

The layout is based on a table "Price Tiers". The layout will pull fields from two other tables based on the relationships shown below.

 

Price Tier Relationships.png

 

This is a mockup of the report I want to create. I'm having problems getting a correct value for the 3rd column - Count Users in Tier. A calc field in ORGS that counts records in Users is not giving me the correct count. The value in the 2nd column (Count Orgs In Tier) is correct. It shows the total count of all Orgs in each Price tier based on the relationship between Price Tiers and Orgs.

 

Price Tiers.png

For each Price Tier, I also want to show the total count of Users from the User table. Any help would be appreciated.

Outcomes