+ sign on my amounts
But assuming this isn’t csv and we can’t do that, your other option would write a calculation to remove the first char.
so I think something like:
if _MYCOLUMN.Trim().SubString = “+” then
I can now see the positive amounts by changing to CHAR. But the (+) is still showing so I assume I need to remove that. Tried your statement above but get error: overload resolution failed because no accessible ‘substring’ accepts this number of arguments.
Brenda, another method is to use _MYCOLUMN.Replace(“+”,””).Trim()
This will replace every instance of the plus sign in the string and doesn’t matter if it has a plus sign or not.
If you would like to submit an answer or comment, please sign in to the eOne portal.