topic Formatting 1 Decimal Number to Money? in App Development

Formatting 1 Decimal Number to Money?

cmorri1988 — Wed, 03 Oct 2018 08:29:32 GMT

Hi there,

would like to transform the following numeric 1 decimal values to money within the script?

From To

0 $0.00

0.1 $0.10

0.2 $0.20

1 $1.00

1.1 $1.10

Please can I ask how I might do this?

Thanks

Re: Formatting 1 Decimal Number to Money?

YoussefBelloum — Wed, 03 Oct 2018 08:42:07 GMT

Hi,

I suggest to let is as it is (numeric) and format it as money on the front-end on the properties on the object

Re: Formatting 1 Decimal Number to Money?

cmorri1988 — Wed, 03 Oct 2018 08:46:16 GMT

Thanks, I would like the selection bar to show the finale money values and not an expression however, and so would like to transform within the script and not the front end.

I notice money() creates the desired output when using within an object, but not when applying to the script.

Thanks

Re: Formatting 1 Decimal Number to Money?

cmorri1988 — Wed, 03 Oct 2018 09:26:44 GMT

For anyone interested in doing the same, this solution seemed to work.

Thanks

---------

For i = 0 to 10

Let dec = $(i)*0.1;

Min_Price:
LOAD
MONEY(NUM(RecNo()-$(dec)),'$#######.#0') AS "Min Price",
NUM(RecNo()-$(dec)) AS "Min Price Num"
AutoGenerate(1000000);

Max_Price:
LOAD
MONEY(NUM(RecNo()-$(dec)),'$#######.#0') AS "Max Price",
NUM(RecNo()-$(dec)) AS "Max Price Num"
AutoGenerate(1000000);

next i;

exit script;