REST field to Numeric value

[valem]

Hi all,

I've loaded a field from a rest call. 

CUSTOM CONNECT TO ".......";
RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"id" AS "id_u7",
.....
"amount" AS "amount_u0",
......
"__FK_results",
"__KEY_results",
(SELECT
"data".....
FROM JSON (wrap on) "root" PK "__KEY_root";

[doc]:
LOAD 
[amount_u0] as amount,
.....
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_results]);

All values are correctly loaded, BUT they are considered as TEXT. As consequence if I want to do sum of those values, result is undefined.

I've tried to load value as 

Num#([amount_u0],'0,00') as amount,

but without success. Could you help me? What I'm doing wrong? Thanks a lot.

[Brett_Bleess]

You would need to use Num() function in this case I believe, here is Help link:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Forma...

I always get confused on the # versus non # functions too, it gets even more confusing when you have to combine them to get what you need, maybe one of the other development gurus can chime in too and add some further explanation as to why Num# was the wrong function to use in this case, but I am pretty sure Num() should work for you.

Regards,
Brett