ISACTIVE() function

Returns values for when a dimension item is valid

🗒️ Description

The IsActive 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.

IsActive will return the value of 1 for all periods between the start and end dates. Otherwise it will return the value 0

✏️ Syntax & variables

✅ Expected result & examples

Case 1: Dimension with start / end dates

For a block which has a dimension which has start/end dates enabled then IsActive() will return 1 or 0 for each of the items in each month based on the start / end dates. See below for the expected result for an indicator formula set to IsActive()

Other cases Dimension with start / end date not enabled

IsActive does not apply to dimensions without start/end dates. Therefore for items on a dimension without start/end dates, we can return 1 for all items

Blocks with no dimensions

If a block has no dimensions, and IsActive() is used in a formula, we can assume the value is always 1