I am trying to combine 2 numeric attributes into one alphanumeric one, so I can show this as one attribute in my query:
attribute1 = alphanumeric combined field
attribute2 = shortcut to a numeric attribute of another business object
attribute3 = numeric attribute of the same business object
Then I try to combine the attributes as follows:
bo.attribute1=AS_STRING(ABS(bo.attribute2))+'/'+AS_STRING(ABS(bo.attribute3))
I would assume that the use of function "ABS" would not be necessary as the values are stored as an absolute number in the database. But since it does return a value like "111.0/22222.0" I tried to use this function. But this returns the same result.