AGG Software Forums

Hi,

As I am not familiar with the correct terminology I am having some trouble using the expressions plugin and I was hoping to get some help.

This is what I am trying to achieve.

I want to show true or false if the following Variable is met.

Conditional: IIF
Variable: TYPE
Operator: =

in this case IIF(`TYPE`='N',true,'false')

I have also tried it like this;

IIF(TYPE=N,true,false)

But can't seem to get it to work. If you can please provide an example with my variables above so I can get this working...

Please, try

RESULT = IIF(TYPE='N','Y','N')

Please, note, that IIF function can't return a value with the boolean type. You should change your expression to

RESULT = (IIF(TYPE='N','Y','N') = 'Y')

or simplify it

RESULT = (TYPE='N')