Notifications
Clear all
Power Query
18
Posts
3
Users
0
Reactions
396
Views
re: rounding - PQ defaults to banker's rounding (to nearest even number).
Use the 3rd param in the rounding to get the 'normal' result:
Number.Round(_,1,RoundingMode.AwayFromZero)
Posted : 07/05/2022 7:06 am
Topic starter
Thank you for pointing that out the PQ rounding default.
To be certain, with this particular situation, wouldn't RoundingMode.Up accomplish the same task as RoundingMode.AwayFromZero?
Posted : 08/05/2022 8:51 am
yes, it would - so, all good there 🙂
Posted : 09/05/2022 7:19 am
Page 2 / 2
Prev
