March 16, 200619 yr Newbies 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!
March 16, 200619 yr 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.
March 16, 200619 yr Author Newbies 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.
Create an account or sign in to comment