What is the calculation to display alternate text from a radio button field? | Community
Skip to main content
June 1, 2021
Question

What is the calculation to display alternate text from a radio button field?

  • June 1, 2021
  • 0 replies
  • 365 views

The radio button options contain reoccurring words (e.g. North, South). I'd like to report and group with the option's remain words (e.g. Dade, Broward).

Perhaps it'll require a calculated field and a calculated column. I've tired many variations similar to: IF(CONTAINS(Region,“North Broward”),"Broward”),IF(CONTAINS (Region,“South Broward”),"Broward”),IF(CONTAINS(Region,“North Dade”,"Dade”),

IF(CONTAINS(Region,“South Dade,"Dade”))

It's no longer fun and I'm nearly out of time, Have Mercy

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.