Hello to everybody,
how can I convert ( in LOAD SCRIPT) the string 123456.34 to number 123456.34?
And for negative value string -123456.34 to number -123456.34
I have tried the instruction Num( ) but I cannot understand the syntax to manage the negative value
You can try like num(field) as field_name
Num(String_field) as No_Field
Num() handles negative values also.
Check it whether you have null values in your field.
You should use like this
Num(Field) as Number
Hope it helps
You can Num() or Num#() to format String to Number.
i have tried Num() and Num#() but for negative value, the string remains string and I cannot display on a chart
this is my load script
Num#(Totale,'0.0') as Totale,
Thanks to everybody,
it was simply a problem with format number
if I use in the load SCRIPT
Num#(Totale,'0.00') as Totale,
it works fine
Retrieving data ...