In Service Studio you have the numeric operators presented below.

Unary minus

Yields the negation of its numeric operand.

Allowed Data Types

- (Unary minus)

Text

Long Integer

Integer

Decimal

Boolean

Date Time

Date

Time

No

Yes

Yes

Yes

No

No

No

No

Arithmetic operators /, -, *

Common arithmetic operations.

Allowed Data Types

/, *, -

Text

Long Integer

Integer

Decimal

Boolean

Date Time

Date

Time

Text

No

No

No

No

No

No

No

No

Long Integer

No

Yes

Yes

Yes

No

No

No

No

Integer

No

Yes

Yes

Yes

No

No

No

No

Decimal

No

Yes

Yes

Yes

No

No

No

No

Boolean

No

No

No

No

No

No

No

No

DateTime

No

No

No

No

No

No

No

No

Date

No

No

No

No

No

No

No

No

Time

No

No

No

No

No

No

No

No

Arithmetic operator +

Performs sum operation. When one of the operands is Text, the other operand is cast to Text, and performs the concatenate operation.

Allowed Data Types

+

Text

Long Integer

Integer

Decimal

Boolean

DateTime

Date

Time

Text

Yes

(a)

(a)

(a)

(a)

(a)

(a)

(a)

Long Integer

(a)

Yes

Yes

Yes

No

No

No

No

Integer

(a)

Yes

Yes

Yes

No

No

No

No

Decimal

(a)

Yes

Yes

Yes

No

No

No

No

Boolean

(a)

No

No

No

No

No

No

No

DateTime

(a)

No

No

No

No

No

No

No

Date

(a)

No

No

No

No

No

No

No

Time

(a)

No

No

No

No

No

No

No

(a) The non-text side is cast to Text and then concatenated.