Note: This function can only be used for RELATIONSHIPS and must be created in the relationship tab.
ITEMEND function is used to return a value of a specific function set by the user, of the item that is at the end of the relationship (the TO position or arrow end). This function will return a NULL if there is no direction or both directions set on the relationship.
x = A function chosen by the user that can be used for an item.
Data Type Returned
The data type returned will depend on the function that the user specifies.
ITEMEND(name) will return the names of the item at the end of the relationship.
ITEMEND(start) will return the start date of the item at the end of the relationship.
Using the ITEMEND function to highlight relationships of items where the item that proceeds the item in question has an end date that is before the main item.
IF(ITEMSTART(end)>ITEMEND(start), 0, 1) will return a value of 1 if the preceding item’s end date is later than the succeeding item’s start date.
Using ITEMEND to show items in a specific category that are at the end of a relationship.
IF(ITEMEND(category) == “Category 1”, 1, 0) will return a 1 for items that are at the end of the relationship and are also in Category 1.