Using number from Single Select in calculation formula

Ask the Community Formulas
#1

Hello SB Community,

I am using a single select column with options as predefined numbers, 1 to 6 - representing hours (time sessions). I would then like to multiply the selected option with X (day rate) and output the result in a currency column (total cost).

I can’t get it to work. Is it possible? I would like to use a single select instead of a number field to input hours

Thanks in advance!!

#2

Hi there,

The single select output isn’t a number but a string, so you need to convert it to a number to use it in a math formula:

VALUE({Hours}) * 200