Skip to main content

Convert multiple select field into currency values

  • December 29, 2020
  • 0 replies
  • 4 views

I have a multiple select field that contains currency per time — Example:

“$5/month”"$200/year"
“$12/month”"$116/year"
“$9/month”"$89/year""$300/year"

Most records have two values, some have three values.

I’m trying to split these multiple-choice entries into different fields and have them be currency fields so I can look at averages, etc.

Any suggestions?