I have two look-up fields in my form and I would like to count the instances one of the options is selected. For example, I have Outcome field with "Positive", "Negative", "Unknown" options and I would like to count how many are "Positive".
My progress so far:
1. I found how to do this for check boxes (yes/no fields) so I could manage those ones at least. But I do not want to turn these into yes/no fields because I intend to filter and follow up with the "Unknown"s later.
2. I managed to create a query that tells me how many times each of the three options were used (although for some reason it chose to start with a nameless row with 0 count, see screenshot). Could this be somehow something I can use for the form total field?