Filer - The ability to show Items that match ALL and ANY

LilyLiuAnaplan
LilyLiuAnaplan
in Modeling

Dear Anaplan Experts,

 

Please see the pic attached. I would like to create a filter that shows items that match ALL for three boolean criteria (i.e. show the record if ALL are met) and ANY for two number format criteria (i.e. shows the record if any of them are not equal to zero). 

 

Would it be possible?

 

Thanks,

 

Lily

Tagged:

Best Answer

  • kevin.cho
    kevin.cho
    Answer ✓

    For combinations of logical AND and logical OR, you should create a new line item that incorporates this logic, and then apply that new line item as a filter. 

     

    I.e.

     

    A, B, C are your boolean criteria

    D and E are your number criteria

     

    Create new line item that has formula:


    A AND B AND C AND (D OR E)

Answers

Categories