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

• Comparison

• Logical

---

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