Mutiplication of number and string?

[pacificpear]

hi

Acess/cr10

I have two column probabilitycode(string) and amount(number)

I need to mutiply these two columns.

How do i convert string to number so that it can be calulated
table
probabilitycode amount
0 10
0 20
10 19
12 32


expected result

table
probabilitycode amount newprobapilitycode
0 10 0
0 20 0
10 19 190
12 32 384

thanks
-pp

 

[vidru]

Create a formula:
//@NewProbabilityCode
ToNumber({Table.ProbabilityCode}) * {Table.Amount}

-dave