Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter with multiple conditions

 

This is my formula. I want to add one more condition inside the filter function. But the function is accepting only two conditions.

Please help on this.

Need Help

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    6 years ago

    Hi Anonymous 

    FILTER only admits one filter expression, a boolean (True/False) expression that is to be evaluated for each row of the table.

    FILTER ( <Table>, <FilterExpression> )

    but you can combine different conditions with ANDs and ORs. In fact you are doing that already in what you show, with an &&. What is the problem exactly. What is the condition you want to add and why can you not?  

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      This is my MTD data .

      I want to create YTD for the same.

      I used the following formula for order Entry

       

       
      And the resukt is showing some extra data
      And there is no OE value for opening. And this 1.23 is not adding with Total also.