| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
You can use custom expressions with functions to create custom Report Designer columns as well as Task & Alert and Advanced Pricing Rule Values. You can access various data objects, such as Voyages, Cargoes, Voyage Estimates, and Invoices, as well as many of the data fields within those objects. In addition, custom expressions enable you to use various functions to create formulas that calculate new fields and values that can be added to reports or output as Advanced Pricing Rules, or even to create complex conditional statements in Tasks and Alerts. The functions below are used when building reports, and mastering them will enhance the information you can extract.
...
To see how they can be used in different circumstances, review the Report Designer tutorials and our sample reports.
IF Statements and JOIN Functions
...
Cargo.CPQty > Cargo.BLQty ? "Underloaded" : "Not Underloaded"
Operators
| Operator Symbol | Valid Expressions | Example |
|---|---|---|
| + | String + String Using the + operator with two String types as the operands will concatenate the two strings together and return the value as a string. | VesselName + "-" + VoyageNo MV AKTAIA-1602 |
Numeric + Numeric Using the + operator with two Numeric types as the operands will add the two numbers together and return the sum as a numeric. | 2 + 2 4 CPQty + 10000 CPQty is 30000 40000 | |
Boolean + Boolean Using the + operator with two Boolean types as the operands will return a Boolean that is the result of a logical OR function. | False + False False False + True True True + True True | |
DateTime + DateTime Using the + operator with two DateTime types as the operands will return a number that is the difference, in days, between the two dates. The returned number will be negative if the first operand is an earlier date than the second operand. | 01-Dec-12 + 01-Jan-13 -31 01-Jan-13 + 01-Dec-12 31 | |
DateTime + Numeric Using the + operator with a DateTime type and Numeric type as the operands will return a DateTime value that is the provided date time plus the number of days. | 01-Dec-12 + 5 06-Dec-12 | |
| - | Numeric - Numeric Using the - operator with two Numeric types as the operands will subtract the two numbers and return the difference as a Numeric. | 5 - 3 2 |
Boolean - Boolean Using the - operator with two Boolean types as the operands will return a Boolean that is the result of a logical OR function. | False - False False False - True True True - True True | |
DateTime - DateTime Using the - operator with two DateTime types as the operands will return a number that is the difference, in days, between the two dates. The returned number will be negative if the first operand is an earlier date than the second operand. (This is the same behavior as the + operator.) | 01-Dec-12 - 01-Jan-13 -31 01-Jan-13 - 01-Dec-12 31 | |
DateTime - Numeric Using the - operator with a DateTime type and Numeric type as the operands will return a DateTime value that is the provided date time minus the number of days. | 01-Jan-13 - 5 21-Dec-12 | |
| * | DateTime * DateTime Using the * operator with two DateTime types as the operands will return a number that is the difference, in days, between the two dates. The returned number will be negative if the first operand is an earlier date than the second operand. (This is the same behavior as the + operator.) | 01-Dec-12 * 01-Jan-13 -31 01-Jan-13 * 01-Dec-12 31 |
Numeric * Numeric Using the * operator with two Numeric types as the operands will multiply the two numbers and return the product as a Numeric. | 30000 * .1 3000 | |
| / | DateTime / DateTime Using the / operator with two DateTime types as the operands will return a number that is the difference, in days, between the two dates. The returned number will be negative if the first operand is an earlier date than the second operand. (This is the same behavior as the + operator.) | 01-Dec-12 / 01-Jan-13 -31 01-Jan-13 / 01-Dec-12 31 |
Numeric / Numeric Using the / operator with two Numeric types as the operands will divide the two numbers and return the quotient as a Numeric. | 6 / 2 3 |
| Page Properties | ||||||
|---|---|---|---|---|---|---|
| ||||||
|