Logical Functions Overview

Function editing

Adding a column and filtering

Component

Adding a calculation field

IF

Performs the condition judgment.

IF(Net profit per store>0,“good”,“bad”)

AND

Requires that all the conditions are met.

AND(1+7=8,5+7=12)

Switch

Performs multi-conditional assignment.

SWITCH(1+2,3,"today is Wednesday",4,"today is Thursday")

OR

Requires that any of the conditions is met.

OR(1+7=9,5+7=11)

IN

Judges whether the expression belongs to the set.

IN(1,1,2,3)=1

IN(City, "Beijing","Shanghai","Guangzhou"): For the rows of Beijing, Shanghai, and Guangzhou fields, the function returns 1. Otherwise, the function returns 0.

DEF(SUM(Sales Volume), [], [IN(City, $Component Parameter)]): Calculates the total sales volume of cities within the component parameter values.

NOT

Judges whether the expression does not belong to the set.

NOT(1-2>0)=1

NOT(IN(City, "Beijing","Shanghai")): For the rows not of Beijing, Shanghai, and Guangzhou fields, the function returns 1. Otherwise, the function returns 0.