Skip to main content

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

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

Thanks

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)`? 

  

Link to base

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


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

Reply


Terms & Conditions