ADF and ROUND()?

Question

Hello! @Nasreen Akter

Anyone know how to Round to 2 decimal places in an ADF Pipeline?

Thanks!
Mike

Answer 1

Hey,
you can use dataflow:

https://learn.microsoft.com/en-us/azure/data-factory/data-flow-expression-functions

Answer 2

Hi @Mike Kiser ,

Thank you for posting query in Microsoft Q&A Platform.

In ADF Pipeline round() function is not available. Hence we need to go with below explained work around to achieve same.

Implementation:
If you want to round 123.43467 to two decimal places, you need to multiple 123.43467 with 100(123.43467 *100 = 12343.67), then take only left side part(12343) from 12343.67. And then divide the result (12343) by 100 to get 123.43

Please check below image which has similar logic in expression and got result.
expression used: @string(div(float(split(string(mul(123.43467,100)),'.')[0]),100))

If you would like to do round in mapping data flows then round() function is available there.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators