OR Operator

[siddharthsoam]

Can someone help me on how to use OR operator in expressions?

[sunny_talwar]

Do I have a specific expression you want help with? I am not even sure what are you trying to learn here? An example of what you are looking might help

[siddharthsoam]

For example if I want to count the employee id of people who work in finance or sales department. How would I do it

[prma7799]

= Count({<Dept = {'finance' , 'sales'} >}EmployeeId)

[vvvvvvizard]

if(Color='red' or Color='blue'  or Color='green', 'Its a primary color ' , 'Not a primary color ')

[sunny_talwar]

this would be the set analysis way

Count({<Dept = {'Finance', 'Sales'}>}EmployeeID)

If statement

Count(If(Match(Dept, 'Finance', 'Sales'), EmployeeID))

Count(If(Dept = 'Finance' or Dept = 'Sales', EmployeeID))

[arvind_patil · Accepted solution]

Hi Siddharth,

If you trying to use it in Set Analysis you can use like below:

Sum({<Type-={"A"},Month-={"Jan","Feb"}>+<Type-={"A"},Month-={"Jan","Feb"}>}Sale)

Thanks

Arvind Patil