Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF THEN IF in advanced query editor

Hi,   I'd like to create a column similiar to this Excel-column in Advanced Query Editor: CP REAL =IF([@[CP Raw]]>30;IF(H6368<=20;30;CA6368);CA6368)   The conditional column only allows me to cr...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

    Please see the below

     

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi MattAllington & Mariusz 

 

Thanks for your reply! Almost there. But what I want him to do is basically this:

 

So skip the first THEN and go straight into the else "if" statement.

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous 

 

Wouldn't the below give you a desired outcome?

 

 

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi not really.

     

    Basically what it says is: When BARGE_CP_RAW is greater than 30, use BARGE_CP_RAW, but not if TotalMoves is less then 20. Then use "30".

     

    Your suggestion says: When BARGE_CP_RAW greater than 30 and TotalMoves is less than 20, then 30.

    • Mariusz's avatar
      Mariusz
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Hi Anonymous 

      Please see the below

       

      Regards,
      Mariusz

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.