Arithmetic and Boolean Operators
Table 14. Operators and Their Meanings
| Operator | Meaning |
|---|---|
| + | Addition |
| - | Subtraction |
| * | Multiplication |
| / | Division |
| > | Greater than |
| >= | Greater than or equal to |
| < | Less than |
| <= | Less than or equal to |
| = = | Equal to |
| <> | Not equal to |
| not | Logical negation |
| and | Logical and |
| or | Logical or |
Location operators follow cell variables and are represented as brackets.
Location operators on the left side of a formula define the cell locations at which the formula is defined or applied. You can define only one formula per cell location.
In the following example, the location operator in "Schedule Required"[level(Week)] defines the formula for cell locations at a weekly level.
"Beginning Inventory Units" = "Ending Inventory Units"[previous(Manufacturing)]
"Schedule Required"[level(Week)] = Schedule.required
"Demand Units Avg"[level(Week)] = avg("Demand Units"[sibling (Manufacturing)])
Location operators on the right side of a formula turn a single cell location into a collection of locations.
In the previous example, "Ending Inventory Units"[previous(Manufacturing)] turns into the cell location for the same part but at the previous time period. "Demand Units"[sibling (Manufacturing)] turns into the cell locations that directly reside under the same time period. In this case, it is the collection of cell locations of “Demand Units” for the same part and at all the weeks of the current month.