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

Fredrik Söderholm Pettersson 81 Reputation points
2021-11-29T08:19:59.74+00:00

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?

153303-pq-example.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,988 questions
No comments
{count} votes

Accepted answer
  1. Nazer Mohamed 76 Reputation points
    2021-11-29T13:11:19.917+00:00

    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

    No comments

1 additional answer

Sort by: Most helpful
  1. Fredrik Söderholm Pettersson 81 Reputation points
    2021-11-29T13:29:41.203+00:00

    Hello Mohamed.

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

    Thank you very much :)

    Best Regards Fredrik

    No comments