Why do I sometimes get a return of -1,4209E and so on.

Question

Hello.

Sometimes I get a return of -1,4209E and similar to this to a simple subtraction and I cant't figure out why. Amount is the sum I get from a puchase order from our NAV And Summa OC is extracted from a PDF file.

What is strange is that it's only on a few rows.

Can it perhaps be some hidden characthers the needs to be cleaned in Summa OC from the PDF?

Answer 1

It is possible that the "Amount" or "Summa OC" has some decimal values (eg: 1,000000000000000004) that are rounded off. But the next column does not round off...

So you have two options here

1. easy fix -> format the "Diff Summa" as Number with One decimal place.
2. Force the decimals in "Amount" and "Summa OC" by using ROUND()

Naz

Answer 2

Hello Mohamed.

I used the #1 option, the easy fix and it worked perfectly.

Thank you very much :)

Best Regards Fredrik