if statement with AND construction

[Anonymous]

hi

want to use a simple statement but in the advanced editor of query editor i seems to be missing something....

this is what i have:

Account groups= 999999, 90000 and 87000 plus we have an costcenter in range 240, 200, 250, 300, 270, 777

so if the Account group is 999999 AND the costcenter is in range of 200, 240, 270 then B1. Automatic else NULL

Tried this so far, unfortunately without succes...

if [Account Group] = "999999" and [Costcenter] in ('200', '240', '270') then B1. = failed

if [Account Group] = "999999" &&  [Costcenter] in ('200', '240', '270') then B1. = failed

any ideas?

thanks!

M

[Zubair_Muhammad · Accepted solution]

HI @Anonymous

Try this

if [Account Group] = 999999 and List.Contains({200, 240, 270},[Costcenter] ) then [B1] else null

If the Columns Account Group and Costcenter are of Text Type then use ""

if [Account Group] = "999999" and List.Contains({"200","240", "270"},[Costcenter] ) then [B1] else null