dropdown value to number

[rKiani]

hi 

is any function to work for this job? :

[multi check box property(data sets as a number) ] + [numberal property] = number

i need this result to make a dataset (table)

my multi check box property are numbers but they detect strings and the sum operation doesnt work.

is any way to convert multi check box property value to number ?

thank you

[rKiani · Accepted solution]

thank you

i solved that. i used if with "27" if else,

if [my field] = 1000 then 1000 and ...

and used [my field] insted of dropdown field in table.

[PamCotton]

Hello @rKiani , Happy Friday Jr!

I would like to invite our top experts to share their thoughts. Hi @jonchim @louischausse any recommendations to @rKiani matter?

Thank you,

Pam

[jonchim]

Hey @rKiani

I'm not entirely sure but i think the multi check property is probably being read as a string you may need to convert it into a number value with some javascript?

Could try using single quotes around the numbers to see if that does anything.