OR

If the logical value of any parameter is TRUE, then return TURE; if the logical value of all parameters is FALSE, then return FALSE.

The parameter must be bool type or numeric type.

True (true) and false (false) in the parameter support case, and the case is marked in blue.

The parameter must be bool type or numeric type.

Use the built-in dataset "Regional data analysis" to filter out the data satisfying "contract amount > 500000" or "Refound amount > 100000".

Use the "Filter" in the self-service dataset and enter the formula: OR(contract amount>500000,Refund amount>100000) . As shown below:

Then filter out the data that meets the condition.

More examples: