Post reply

ssrs 2.8421709430404E-14 error when my totals sum to zero

  • April 18, 2012 at 10:28 am

    #392058

    Is there anything i can do to tweak this where in reporting services it will sum if the total comes out to be zero

    =sum(Iif(trim(Fields!PAYROLCD.Value) = "SALARY", CDbl(Fields!UNTSTOPY.Value),CDbl(0)))+sum(Iif(trim(Fields!PAYROLCD.Value) = "SVAC", CDbl(Fields!UNTSTOPY.Value),CDbl(0)))

    an example.

    the filed untstopy has 3 results

    86.7

    86.7

    -173.34

    I should get zero when summed witht he code above, but i'm getting

    2.8421709430404E-14

  • April 18, 2012 at 10:55 am

    #1475502

    What is the data type of the column in question?

  • April 18, 2012 at 11:05 am

    #1475519

    numeric(19,5)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply