Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How to put multiple filter conditions in a query?

Hi,   My below query is not working, it says I can give only 3 filter conditions for OR.   Loan Number MTD = IF(Enco[Current_Month_FileStarted] = 1 || Enco[Current_Month_Application] = 1|| Enco[C...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    8 years ago

    If the || operator is not working, you will have to nest multiple ORs

     

    Measure =
IF( OR (CondA, 
         OR (CondB,
           OR(CondC, CondD))),
TRUE,
FALSE)

    Hope this helps

    David

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I am getting this error for the query I posted, Too many arguments were passed to the IF function. The maximum argument count for the function is 3.

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
8 years ago

If the || operator is not working, you will have to nest multiple ORs

 

Measure =
IF( OR (CondA, 
         OR (CondB,
           OR(CondC, CondD))),
TRUE,
FALSE)

Hope this helps

David

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks David, it worked!! This community is great.