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

    Wrong sum



      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;