Forum Discussion

non23's avatar
non23
Icon for Helper I rankHelper I
1 year ago
Solved

How 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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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 He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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 He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly