1 Reply Latest reply: Feb 26, 2018 12:48 PM by Ishtdeep Singh RSS

    working with decimal in script

    everest226 KC

      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)