Apr 02, 2023 07:32 PM
so i have a table to thats shows a field with top 10 finishes which is a formula field that uses the below formula
Apr 03, 2023 01:58 AM
Hmm, what if you added a filter to only show records where "Top_10_Finished" = 1, and then grouped by the driver field?
Apr 03, 2023 06:26 AM
That doesnt give me a sum just shows the records of all the ones that have oned
i need to add those all up like using sum then do a filter or sort so for example. Jaycie has 2 records with ones in top 10 finishes field. Then i can show driver “Jaycie = 2 top 10 finishes. Then i can use the share code to display on website
Apr 04, 2023 08:45 AM
Once you've grouped it you should see the counts, right?
It sounds like you want to see a table where each record represents a single driver and have a field that displays how many top 10 finishes they have?
If so, you'll need to create a table where each record is a driver and link each of them to all of the races. After that you can add a "Count" field and add a conditional to it to only display "Top_10_Finished" = 1