Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

add conditional column

How to add 'and' under 'add conditional column'?    if 'target' is great than 2 and *****, then ***
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Anonymous

     

    In order to do that you will need to add a Custom Column


    The syntax is the following below and NOTE that it is case sensitive

     

    if [Target] > 2 and [Other column] = "Closed" then "My Output Closed"
else if [Target] > 1 and [Other column] = "Open" then "My Output Open"
 else "Other Output"

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

GilbertQ yes, i'm in edit queries/add column/conditional column.  but where to add 'and'

 

for example below, how should i say

if actualstart = 11/07/2017 and (or) ****, then output = 13/07/2017. 

 

 

GilbertQ's avatar
GilbertQ
Super User
9 years ago
Hi there, instead of using the Conditional Column use the Custom Column and then paste the code in there.

Currently with the Conditional Column it does not allow you to put in the "and"