How does one handle AND/OR operations within the function pane of Grid Tools?

[James Chan]

Example: 

Ideally the this: @if(~ITERATION~=4,@if(~PUBROW~=40,START,END)@,END)@

Could be simplified to something like: @if(@AND(~ITERATION~=4,~PUBROW~=40)@,START,END)@

[James Chan]

I have another update on this.

 

We have discussed this with engineering and they agree that creating new functions to support Boolean logic will make the tool more user friendly. ERs have been created.

 

In the meantime, most binary logic can be performed using the @if and @case functions.

[James Chan]

It turns out that we don’t have much support for boolean logic outside of the if and case functions in the data painter window.

 

What you’re doing is the best approach at the moment.