Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

if statement with AND construction

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 cos...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

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