Filter radio button value in calculation

[dalty52]

Hi. I have a radio button value list of "yes" "no" and "maybe". Also, on each record, I have a field that is a numeric value called "total number of people". I am trying to figure out how to create a summary calculation of the "total number of people" value, but only using the records where "yes" or "maybe" is selected in the radio button. Thanks for your help!

[comment]

Define a calculation field (result is number) =

Case ( YourRadioField = "Yes" or YourRadioField = "Maybe" ; total number of people )

Summarize the calculation field using a summary field.

[dalty52]

Awesome! Thank you! I had come to the conclusion that I needed to use the case function somehow, but, I never thought about needing to make two fields for it. Worked like a charm.