-with-space.png){kind=logo}
ISEND() function
🗒️ Description
The IsEnd function is to be used alongside the Start/End functionality within dimensions. When Start/End functionality is switched on for a dimension, each item will have a start or end date.
IsEnd will return the value of 1 for the period which corresponds with each item's End period. Otherwise it will return the value 0.
✏️ Syntax & variables
| 1 | IsEnd() |
|---|
It can be chained with other functions or values eg
| 1 | "New customers” * IsEnd() |
|---|
✅ Expected result & examples
Dimension with start/end enabled
For a block with a dimension which has start/end dates enabled, then IsEnd() will return 1 or 0 based on when each item has it’s end value.
- If there is no end value (end = Blank), all time periods will be 0
- If there is an end value, we put 1 in the relevant time period
See below for expected result
Other Cases: Dimension with start / end date not enabled
IsEnd does not apply to dimensions without start/end dates. Therefore for items on a dimension without start/end dates:
- Return 0 in all time periods for all items
Blocks with no dimensions
If a block has no dimensions, and IsEnd () is used in a formula:
- Return 0 in all time periods