Problem with simple if statement containing "and"

[#1]

Hi,

This statement is not working for me.

Anyone got a clue of what is wrong?

If("t_invc"=1 and "t_rtrn"=0,1,0) as Flag_InternalSales, // 1=Yes,0=No

Freddy

[nilo_pontes]

Remove the quotes Freddy

Regards,

Nilo

[alexandros17]

If(t_invc=1 and t_rtrn=0,1,0) as Flag_InternalSales

[#4]

Hi, thanks for the input. Do not work to remove quotes as the data model has these quotes from the database.

[jer_2011]

hello try so If(t_invc=1 or t_rtrn=0,1,0) as Flag_InternalSales

[#6 · Accepted solution]

Hi. Sorry guys. "t_rtrn" do not have 0 as a value. Only 1 and 2. That explains it. Thanks again.

[stigchel]

I'm not sure about the quotes, I would remove them in load script.

If not possible you can try if this helps (not sure):

If(["t_invc"]=1 and ["t_rtrn"]=0,1,0) as Flag_InternalSales

[#8]

Try with this:

If("t_invc"=1, if("t_rtrn"=0,1,0)) as Flag_InternalSales, // 1=Yes,0=No