Plus sign operator in Calculated Field using Simple Formula

Hi Nick,

I will have to test this, I know Oracle handles some concatenation functions differently. If you can let me know what specific outcome you are looking for I can help provide the query you need for this.

Cheers,

Neal

Hi Neal,

Hope you are well.

Just wanted to confirm if you were seeing the same thing with the + sign operator when the underlying db is mssql vs oracle db for the following calcs below.

So in the case of mssql where you have:

char_field + char_field, I expect the result to be "<char_field value><char_field_value>"

num_field + num_field, I expect the result to be the addition of both fields

Whereas, in Oracle, I'm getting "ORA error invalid numeric field" for both scenarios above using the exact same calculations

Thanks,

Nick

Hi Nick,

I have tested this on my Oracle instance, and the char_field + char_field does result in that issue, but the num_field + num_field for mine works as expected. The reason for this not working is just down to the way Oracle handles the "+" operator compared to MS SQL. To achieve the same function for the char_fields, please use a Freehand SQL type and use on of the following methods:

CONCAT(char_field, char_field2)

OR

char_field || ' ' || char_field2

The number field seems odd though. Would you be able to send through some more specifics on the fields, their underlying types and direct example?

Cheers,

Neal

Hi Neal,

Thanks for the confirmation.

For the numeric field, no need to worry about it. I was able to sort it out from my end being mainly due to improper use of the + sign operator as well.

Enjoy the week ahead :)

Thanks,

Nick

Hi Nick,

Great to hear. Enjoy your week as well.

Cheers,

Neal