How to set number of decimal places

daveinhants

• May 06, 2016 00:00

• Answered

Follow

Apologies that this is such a stupid question!

Please could someone advise what function to use to set the number of decimal places of a number(long), using the Transform Editor. So I just want to set 1.9993335 to be 1.99

Thanks!

Dave

• 

  Pedro Vazquez Rosario

  • May 09, 2016 15:15

  0

  Comment actions Permalink

  Hi,
  
  I would recommend two options depending if you want to round the decimal value or not:
  

  • You can change the metadata type from number to decimal (will not round the value), also make sure you specify the precision in property Scale
    
  • Use a Reformat component and in the CTL code use function round (you can find more information on how round here)

Please sign in to leave a comment.