ADD (+)
Use the '+' (plus) sign to add values of some type of number.
Syntax
number1 + number2 + ... |
Inputs
number1 - First number or attribute of some type of number to add.
number2 - Second number or attribute of some type of number to add.
Return types
number + number = number
integer + integer = integer
currency + currency = currency
percentage + percentage = percentage
number + integer = number
number + currency = currency
number + percentage = percentage
integer + currency = currency
integer + percentage = percentage
- currency + percentage = error
Examples
Suppose the following data model:
| Entity.attribute | Value | Type |
|---|---|---|
| Child.pocketMoney | 2.50 | Currency |
| Bonus.standard | 5.00 | Percentage |
| Expression | Result | Type |
|---|---|---|
| Child.pocketMoney + 3.00 | 5.50 | Currency |
| Child.pocketMoney + 3 | 5.50 | Currency |
| 2.50 + 3 | 5.5000 | Number |
| 100 + Bonus.standard | 105.00 | Percentage |
| Child.pocketMoney + Bonus.standard | Error |