How to Fix the Formulas for Total Open AI Cost Calculation

·

Trying to make a “Total Open AI Cost” coloumn (https://app.clay.com/workspaces/74351/tables/t_IcVXd1Rv04oc/views/gv_qrIQ7jwk8tm3) But my formular, is instead of adding them together just conjoining the numbers together… Any Ideas?

· Sorted by Oldest

Liam M.
·
·
The coloumn is all the way to the right
Clay Team
APP
·
·
Hi Liam, thanks for getting in touch! check this formula please:
5f73591d-b583-44c1-be11-c7c1210c7c1f.png(99 kB)
33da5e3f-790f-4b1c-a738-9d743b95a46c.png(30 kB)
Clay Team
APP
·
·
You need to transform the type of data from string to float by removing "$" sign, then this can be sum

Liam M.
·
·
The coloumn is all the way to the right
Clay Team
APP
·
·
Hi Liam, thanks for getting in touch! check this formula please:
5f73591d-b583-44c1-be11-c7c1210c7c1f.png(99 kB)
33da5e3f-790f-4b1c-a738-9d743b95a46c.png(30 kB)
Clay Team
APP
·
·
You need to transform the type of data from string to float by removing "$" sign, then this can be sum