ISEND() function

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.

It can be chained with other functions or values eg

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

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

If a block has no dimensions, and IsEnd () is used in a formula:

• Return 0 in all time periods