Forum Discussion
non23
Helper I
Helper IHow to resolve floating numbers in PQ - addition
Hey guys, I'm trying to add two columns to the PQ. Sales: 1012.55 Tax: 101.26 Total: 1113.81 but when I add a custom column for the Total it will show as 1113.80499999999. How can I fix this ...
Hi non23 ,
Based on your description, it's not clear how your TAX column is formed; if it's said to be derived from a ratio multiplied by sales, it's easy to see why you have so many decimal places. And based on your results, rounding would end in either 8 or 805, it wouldn't round up plus one. So you might try using Number. round() twice.= [Sales] + Number.Round(Number.Round([Tax],3),2)Final output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
