working with decimal in script

everest226 — Mon, 26 Feb 2018 17:43:23 GMT

I have following script which will output PI amount in excel file , how to round up into 2 decimal Pi amount

Concatenate(Export)

LOAD

'PI Amount' as 'Category',

[ Code] as G1,

[Destination] as D1,

[ Type] as T,

[Departure Month] as TM,

[ Fee] as Amount

Resident Header Where IsrarH= 'T' AND

[Departure Date] >= $(vStartdate) and [ Departure Date] <= $(vEnddate)

Re: working with decimal in script

isingh30 — Mon, 26 Feb 2018 17:44:58 GMT

To Round to two decimal places, you would use Round(field, '0.01').

See page 393 of Book I in the Reference Manual.

Thanks.