Sum of negative values (minus sign behind the number)

[#1]

Hi,

I´m new in QV and I have a lot of questions so far. But I´m happy to found this community and I hope you could help me.

I have attached a file from SAP which includes positive and negative values. I was trying to build a sum of them in QV but the negative numbers will not be considered because the minus stands behind the number. (see Appendix)

How can I modify the number so the minus sign stands BEFORE the number.

In Excel I would try something like this:

= IF (RIGHT (A1; 1) = "-"; "-" & A1; A1)

Thanks for your help and best regards

Thomas

[Gysbert_Wassenaar]

Please post a small Qlikview document with some data. I don't think Qlikview would load numbers from SAP this way unless they're not really numbers but text values and they don't match your default document number format. If they are text values then you need to convert them to numbers in the script with the num# function.

[marcus_sommer]

See: Reading SAP data that is positive and negative

- Marcus

[kamal_sanguri]

this excel logic can also be applied in qlikview

[kamal_sanguri]

pls refer attached sample qvw.