Equivalent of TONUMBER in CBAS?

Analytics
2

Hi Matthew,

For now, you can use:
-- bigint(..), if you know all the numbers are integers;
-- double(..) otherwise.

For example:
– bigint("+18029412") returns 18029412
– double("+18029412") returns 1.8029412E7

Eventually, the analytics service will support the TONUMBER function as well.

Best,
Yingyi

1 Like