This content has been marked as final. Show 3 replies
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.
This is were I lost it.
No idea why this is happening. Hope you do.