Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
To Round to two decimal places, you would use Round(field, '0.01').
See page 393 of Book I in the Reference Manual.
Thanks.