3 Replies Latest reply: Feb 14, 2014 4:37 AM by Kristel Borremans RSS

    Wrong sum

      Hello;

       

      I am loading a spreadsheet that has been saved as a text file to speed up the download.

      Because of that the trailing minus is not respected.

      I can solve the problem apply this:

       

      num(if(right([Inv Amount],1) = '-',0-left([Inv Amount],len([Inv Amount])-1),[Inv Amount])) as [Inv AmountNum]

      The numbers are correctly being retrieved.

       

      The problem comes when I apply a sum with the field in question in an expression.

       

      Sum issue.jpg

       

      This is were I lost it.

       

      No idea why this is happening.  Hope you do.

       

      Many thanks;

       

      Kristel