Gold Operators#

Through operators, users can perform specific operations on variables and constants, which, as previously said, can differ by their type.

In this page, all the operators are listed, along with all the possible combinations.

Note

The following tables contain all the operators available in GOLD and the result for each combination between types.

The operator types available are:


Arithmetic Operators#

In this section, each table contains all the possible combinations between types using the following arithmetic operators:

+

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

No

Nominal

No

No

No

No

No

No

No

No

No

No

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

No

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

No

Nominal

Continuous

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

No

Nominal

Percentage

Percentage

Percentage

Currency

No

No

No

No

No

No

No

Nominal

Currency

Currency

Currency

Currency

No

No

No

No

No

No

No

Nominal

Date

Date

No

No

No

No

No

No

No

No

No

Nominal

Datetime

Datetime

No

No

No

No

No

No

No

No

No

Nominal

Time

Time

No

No

No

No

No

No

No

No

No

Nominal

Month

Month

No

No

No

No

No

No

No

No

No

Nominal

Week

Week

No

No

No

No

No

No

No

No

No

Nominal

Quarter

Quarter

No

No

No

No

No

No

No

No

-

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

No

Nominal

No

No

No

No

No

No

No

No

No

No

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

Nominal

No

Nominal

Integer

Continuous

Percentage

Currency

No

No

No

No

No

No

No

Nominal

Continuous

Continuous

Percentage

Currency

No

No

No

No

No

No

No

Nominal

Percentage

Percentage

Percentage

Currency

No

No

No

No

No

No

No

Nominal

Currency

Currency

Currency

Currency

No

No

No

No

No

No

No

Nominal

Date

Date

No

No

Integer

Time

Time

Integer

Integer

Integer

No

Nominal

Datetime

Datetime

No

No

Time

Time

Time

Time

Time

Time

No

Nominal

Time

Time

No

No

No

No

Time

No

No

No

No

Nominal

Month

Month

No

No

Integer

Time

Time

Integer

Integer

Month

No

Nominal

Week

Week

No

No

Integer

Time

Time

Integer

Integer

Integer

No

Nominal

Quarter

Quarter

No

No

Integer

Time

Time

Integer

Integer

Integer

*

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

No

No

No

No

No

No

No

No

No

No

No

No

No

No

Nominal

No

No

No

No

No

No

No

No

No

No

Nominal

Integer

Continuous

Percentage

Currency

No

No

No

No

No

No

No

No

Continuous

Continuous

Percentage

Currency

No

No

No

No

No

No

No

No

Percentage

Percentage

Percentage

Currency

No

No

No

No

No

No

No

No

Currency

Currency

Currency

Currency

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

/

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

No

No

No

No

No

No

No

No

No

No

No

No

No

No

Nominal

No

No

No

No

No

No

No

No

No

No

No

Continuous

Continuous

Percentage

Currency

No

No

No

No

No

No

No

No

Continuous

Continuous

Percentage

Currency

No

No

No

No

No

No

No

No

Percentage

Percentage

Percentage

Currency

No

No

No

No

No

No

No

No

Currency

Currency

Currency

Currency

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

^

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

Integer

Continuous

Percentage

Currency

No

No

No

No

No

No

No

No

Continuous

Continuous

Percentage

Currency

No

No

No

No

No

No

No

No

Percentage

Percentage

Percentage

Currency

No

No

No

No

No

No

No

No

Currency

Currency

Currency

Currency

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

%

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

No

No

No

No

No

No

No

No

No

No

No

No

No

No

Nominal

No

No

No

No

No

No

No

No

No

No

No

Integer

Continuous

Percentage

Currency

No

No

No

No

No

No

No

No

Continuous

Continuous

Percentage

Currency

No

No

No

No

No

No

No

No

Percentage

Percentage

Percentage

Currency

No

No

No

No

No

No

No

No

Currency

Currency

Currency

Currency

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No


Comparison Operators#

== > >= is

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary

Binary


Logical Operators#

and or

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

Nominal

Integer

Continuous

Percentage

Currency

Date

Datetime

Time

Month

Week

Quarter

Binary

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No

No