Hi at all,
I'm a new Retool user, and I hope to be a persistent user
I'm having a problem with a numeric column, that is saw in the statistics modules of Retool as a string.
1 - My column in Oracle is a Number :
2 - The result of my Query (when I run It in DBEAVER) is a number :
3 - When I try to add the value, I've got this message that is teling me that my result is not a number but a string :
My request looks like this :
SELECT SUM(CA)
FROM TABLE.CDEE
When I add It into a column, it shows a number :
Do someone has an issue ?
I read a lot of posts on Retool community help, that are speaking about the same problem on Postgre. I tried a lot of things, but nothing is working !!!
Ex : Convert the result into an Integer, but I think I don't use the good way :
Do you have an idea of what I can do to use the result of my SQL Request as a number, to use statistics tables ?
PS : I think I will start to learn Javascript, because as I understand, It's better to know this language to use retool !!??
Big thanks by advance !!