When using prices, for example when calculating invoice lines, it is important to round the numbers before you make a total calculation. To prevent a difference in the calculated total (if this is a float) and the actual sum of all lines.

I didn’t find an easy way to round decimals in Flow. Actually I feel al bit embarrassed for this solution. What I found out in the various forums and the best solution for now for me was:

div(float(int(first(split(string(mul(variables(‘Float value’),100)),’.’)))),100)

Actually this isn’t a round; the decimals are cut after the second one. But it worked for me. Anyone who has a better solution?

More info in this post: https://powerusers.microsoft.com/t5/Building-Flows/Format-decimal-numbers/td-p/71073

Laat het ons weten!

Neem gerust contact op als je wat meer van onze dienstverlening wilt weten.