SAP :X

[Eric]

SAP Drives me crazy!

Anyone deal with a system sending negative number fields as "1-". It obviously errors on TI. Any tips or tricks or do i need do the following.

"To frustrated to write actual code"

IF Last character of string ="-"
Remove last character and convert to number then * -1
Else
convert string to number.

[Mike Cowie]

Eric,

I don't know of a natural way to make TI understand such a number format - maybe someone else does. I think you're stuck with a formula here. So, let's say you have a variable called "Amount" and Amount = 12345.67-

To make this work properly and avoid annoying errors, you'll need to make the Amount variable a String type in TI.

Then in a custom variable, let's call it "ConvertedAmount" (make it Numeric TI variable type) you could have a variable like the following:

Code: Select all

ConvertedAmount = IF( SUBST( Amount, LONG( Amount ), 1 ) @= '-', -NUMBR( SUBST( Amount, 1, LONG( Amount ) - 1 ) ), NUMBR( Amount )); 

Hope that helps.

Regards,

[Eric]

That is what I thought (fear).

Thanks for suggesting 2 variables in self loathing I might have overlooked that and caused more headaches for myself.

[Mike Cowie]

Eric,

There may also be some things you or someone can do to the data source to get values in a more readily consumed format, but in my experience getting someone to do work on any SAP like modify an ABAP report doesn't happen quickly. Good luck.

Regards,