IN

Version

Function Description

The IN function is used to determine whether the result of an expression belongs to the set constructed by parameter 1, parameter 2, parameter 3, ..., and parameter N. If the result of the expression belongs to the set, the returned value is 1. Otherwise, the returned value is 0.

1. All parameters in the IN function must be of the same type.

2. When parameter 1 of the IN function is a component parameter and is assigned multiple values (for example, a component parameter bound to a filter component and configured with multiple values), a component error will occur, saying "The first parameter of IN cannot be a multivalued parameter", as shown in the following figure.

For example, you can use the function to calculate the contract amounts of long-term orders in Contract Fact Table.

1. Create an analysis subject, and upload the data table Contract Fact Table. Create a component with the table, select Add Calculation Field to add a calculation field, and name the field Long-term Order or Not.

When the contract type is Long-term agreement or Long-term agreement orders, the order belongs to the long-term order. Enter the formula: IN(Contract Type,"Long-term agreement orders","Long-term agreement")

Note:

Contract Type in this formula is not manually entered, but selected from the fields on the left side.

When you add fields to the component, the values for long-term orders are set to 1, while all others are set to 0, as shown in the following figure.

2. To calculate the contract amounts of long-term orders, add a calculation field with the formula DEF_ADD(SUM_AGG(Total Amount),[],Long-term Order or Not).

Only the contract amounts of long-term orders are displayed in the component, as shown in the following figure.

You can display the total contact amount in a KPI card, as shown in the following figure.

2. The following table shows more examples.