Calculation - IsSelected

Example of using isSelected function from a Targit calculation in the Datamodel editor.

Cost Amount (Actual):

Iif(isSelected([Currency Selector], [Currency Selector].&[Local Currency]), [Cost Amount ( Actual ) Local Currency], Iif(isSelected([Currency Selector],[Currency Selector].[USD]), [Cost Amount ( Actual ) USD], [Cost Amount ( Actual ) USD]))

So this example basically uses a Dimension called Currency Selector which has 2 values in it:

• USD
• Local Currency.

The data model has 2 physical measures:

• [Cost Amount ( Actual ) Local Currency]
• [Cost Amount ( Actual ) USD]

The Currency Selector dimension is typically added to the Criteria bar in the TARGIT client:

• When the user selects Local Currency, it will return the [Cost Amount ( Actual ) Local Currency] measure.
• When the user Selects USD, it returns the [Cost Amount ( Actual ) USD] measure.
• When nothing is selected, it defaults to [Cost Amount ( Actual ) USD].