Register

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

LILYLIU
Contributor

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

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

3 REPLIES 3
kevin.cho
Certified Master Anaplanner

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

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)

rob_marshall
Moderator

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

@LILYLIU 

 

@kevin.cho is exactly correct, please see Planual rule 4.03-01 

 

Rob

LILYLIU
Contributor

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

Hi Kevin, Rob, Thank you so much!!