topic I cannot calculate the difference between two data. in Product Forum

I cannot calculate the difference between two data.

bazygon — Sat, 17 Feb 2024 15:54:00 GMT

I would like to count differnece betwen past day price and current price of BTC.

I think that the problem might be with "$" and "," in my text data. What should I do to fix this? My idea with ToNumber Doesn't work.

------------------------------
Norbert Florczak
------------------------------

Daniel_Sanhueza — Sun, 18 Feb 2024 03:45:00 GMT

Hello Norbert,

You are thinking correctly, you can't cast that when there's a character that is not a number. You can solve that by simply using a nested function

ToNumber(Replace([BTC Past Day Price ],"$",""))

Before convert, you have to replace the characters that are not a number.

Regards

------------------------------
Daniel Sanhueza
RPA Professional Developer
Deloitte
America/Santiago
------------------------------

bazygon — Sun, 18 Feb 2024 22:18:00 GMT

Thank you very much for your help!

------------------------------
Norbert Florczak
------------------------------

asilarow — Wed, 27 Mar 2024 06:51:26 GMT

You can also do it without replacing any characters:

ToNumber(Right([BTC Past Day Price],Len([BTC Past Day Price])-1))

This is assuming that the dollar sign will always be present, and as the first character from the left.

If it's variable, then you will need to use InStr() to find it first, and then calculate how many characters to use based on its location.