Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me on how to use OR operator in expressions?
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
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
For example if I want to count the employee id of people who work in finance or sales department. How would I do it
= Count({<Dept = {'finance' , 'sales'} >}EmployeeId)
if(Color='red' or Color='blue' or Color='green', 'Its a primary color ' , 'Not a primary color ')
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))
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