Round to 2 decimals
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?
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:
Post is closed for comments.