With the proprietary Oracle Primavera Portfolio Management (PPM) syntax, the following methods which can be used when defining horizontal functions:
Category | (Syntax) |
|---|---|
Syntax | "category" |
Arguments | category A name of a category |
Description | Represents the current value of the category cell. |
Example | "income" - "expense" Income and expense are categories in PPM. |
getValueList (Syntax) | |
|---|---|
Syntax | getValueList("valuelist","value") |
Arguments | valuelist A name of a value list. value A name of a value in the specified value list. |
Description | Returns a float that specifies the value's weight. This syntax can be used to compare value list variables. |
Example | If "Risk" is a value list category with "High", "Medium" and "Low" values, then the following horizontal formula is valid: ("Risk" == getValueList("Risk","High"))?1:0 ?: is the JavaScript conditional operator. The formula returns 1 if the items Risk is high, otherwise it returns 0. |
Reserved Words
today (Reserved Word) | |
|---|---|
Syntax | today |
Description | today is an integer that represents the current date. This property returns the number of days since 1753 until the current date, which can be compared with the any other date type parameter. |
Example | "End Date" - today In this example, if the result is positive, the cell displays the number of days left until the planned end date. If the result equals 0, then the planned end date is today. If the result is a negative number, then the cell displays the number of days that have passed since the end date. |
red / yellow / green (Reserved Words) | |
|---|---|
Syntax | red yellow green |
Description | red, yellow, and green are integers that represent the different indicator values. |
Example | ("Health" == red)?0:1 ?: is the JavaScript conditional operator. The formula returns 0 if the items Health is red, otherwise it returns 1. |