LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  operation of subtraction fails (with double data type)

    Employee
    Posted 10-13-2015 06:59

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Rafael

    Hello,

    From an Excel file, I load a few simple data (unicode). The numeric columns are transformed to double data type and makes a subtract operation for creating a new column with the result. The operation does not show the correct solution. This is the example:

    C1 2142,86
    C2 158,75
    C3 367,29
    C4 0
    C5 1616,82
    RESULT 2,27E-02

    C1 166,54
    C2 10,58
    C3 28,55
    C4 0
    C5 127,41
    RESULT -2,84E-03



    The calculations I do with LAE is: [C1-C2-C3-C4-C5=RESULT]

    The RESULT column should be zero (0), but the value is other than zero.

    Any one has done a similar problem and know the solutions?

    Thanks.


  • 2.  RE: operation of subtraction fails (with double data type)

    Employee
    Posted 10-13-2015 15:14

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    It seems to work fine for me. See attachment.
    Attachments:
    calculation.zip