How to truncate decimal places

• function to use
  floor()
• How to Use
  ...| eval <field name to put result>=floor(<number or field name to truncate>)
  
  example:
  ...| eval n=floor(1.9)
  * "1" is returned for n.
  
  ...| eval XXX=floor(AAA)
  *If the value of the AAA field is "1.9", "1" will be returned to the XXX field.

How to round decimal places

• function to use
  round()
• How to Use
  ...| eval <field name to put result>=round(<number or field name to round off>)
  or
  ...| eval <field name to put result>=round(<number or field name to be rounded down>, rounding place)
  
  example:
  ...| eval n=round(3.5)
  * "4" is returned for n.
  
  ...| eval n=round(2.555, 2)
  * "2.56" is returned for n.
  
  ...| eval XXX=round(AAA, 2)
  *If the AAA field value is "2.555", "2.56" will be returned in the XXX field.