Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Count of records not adding up correctly

Solved
Jump to Solution
1286 0
cancel
Showing results for 
Search instead for 
Did you mean: 
asher
4 - Data Explorer
4 - Data Explorer

asher_0-1675672759815.png

The bottom one should be a count of 2. Team A and Team B are two fields. I tried COUNT, COUNTA, COUNTALL

Here's the formula

asher_2-1675672843174.png

I can't even add a Count to that specific field

asher_1-1675672797532.png

Thanks

1 Solution

Accepted Solutions
pressGO_design
10 - Mercury
10 - Mercury

Duplicate the Team Splits field and turn that new field into a Rollup, then use the COUNTA function in the Rollup.

See Solution in Thread

3 Replies 3
pressGO_design
10 - Mercury
10 - Mercury

Duplicate the Team Splits field and turn that new field into a Rollup, then use the COUNTA function in the Rollup.

Yeah it's a weird one sigh.  A possible solution could be to add a `Count` field to the junction table you've got, and then adding a rollup field on your main table with a `SUM(values)`? 

Screenshot 2023-02-07 at 9.54.52 AM.png

Screenshot 2023-02-07 at 9.54.57 AM.png

Screenshot 2023-02-07 at 9.55.00 AM.png  

Link to base

This worked like a charm! Thank you both for your suggestions.