Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

working with decimal in script

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)

1 Reply
isingh30
Specialist
Specialist

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

See page 393 of Book I in the Reference Manual.


Thanks.