Create a vbscript function to format a number in load table

doplear01 — Wed, 09 Sep 2015 18:01:22 GMT

How can i create a vbscript function that format a number? I need to use this function in a load statement

something like this:

/* in thevbscript */

sub FormatFunction(field)

FormatFunction = num#(Cost, '#.#', '.', ',')

en sub

/* in the qlikview editor */

TBL:

Load

FormatFunction(comision) AS Comision,

FormatFunction(fee) AS Fee

autogenerate(1);

topic Create a vbscript function to format a number in load table in QlikView