Time to Number

[HeyItsDoug]

Hi,

I have a text field containing for example:   10.30  The value will always be xx.xx     How can I convert this text value(numbers) to a number datatype that I can use for aggregating?  I've tried to use CONVERT but I cant figure out which datatype to use.  Ideally, I'd like to do this conversion within a table formula so I can use it in multiple places within my application.

Any help appreciated!

Doug

[sandy159]

Hi @HeyItsDoug,

To use text values as numbers, you may convert them explicitly to Float like this: CONVERT(float, [@field:text])

You can add it to the Formula field in the table or in the Calculated field on the DataPage.

More about Convert function can be found here: 
https://www.w3schools.com/sql/func_sqlserver_convert.asp
https://howto.caspio.com/function-reference/

[HeyItsDoug]

Sandy159,

That worked perfectly!

Thank you!