Forum Discussion

NikkiWalters's avatar
NikkiWalters
Qrew Cadet
6 years ago

Formula to take a rating (text - multiple choice field) and pull the numeric digit out into a numeric field

I have a text field - multiple choice rating field [Rating Category] with the list of choices as shown in the formula below. I need a second field, numeric, so I can total & average the ratings.  I se...
Formulas and functions
NikkiWalters's avatar
NikkiWalters
Qrew Cadet
6 years ago
Thank you both.  Alex, very helpful for future formulas.  Mark, worked like a charm.  The average seems to be working too, but is there a way to reduce the decimal points in a summary report?