Round to 2 decimals

David Paras

• August 11, 2015 16:27

I need to multiply a value in the Mapper and then subtract that from another number...but when I do it comes back with a number like 20.560000000000002. I need this to appear as 20.56. I tried round, but it changed it to 21 and format-number doesn't work because the number isn't a string. How can I do this?

0

• 

  David Paras

  • August 11, 2015 16:27

  This can be achieved by using the format-number function. By using the format number function you can specify the decimal places by increasing the count of # in below format:

  format-number($Input_SourceSchema/Root/Record/amount,'#.##')

  0

Post is closed for comments.