topic Re: Exclude rows based on two columns and list values in App Development

Exclude rows based on two columns and list values

Yury — Wed, 22 Dec 2021 17:26:36 GMT

Hello Experts ,

I need to exclude rows in the table based on two columns information.

For example, I have a list of materials like 'A','X','Y','Z' and i need to exclude all invoices where this materials exist

For source below I need to exclude three first rows where invoice is 111 as it contain material from the list - 'A'

I'm really not good in set analysis, so, please help me to write down correct expression.

Thank you!

Rodj — Fri, 20 Dec 2019 01:51:57 GMT

You can exclude sets by using the "-=" symbol in your set modifier, like so:

sum({$<Material -= {'A'}>} YourMeasure)

To do it for all values of Material as you appear to want to do:

sum({$<Material -= {"*"}>} YourMeasure)

You can also look to use the 'P()' and 'E()' element functions to do things like this.

Hopefully what you need is somewhere in there, I wasn't entirely clear on what you are trying to do.

Cheers,

Rod

sunny_talwar — Fri, 20 Dec 2019 02:18:53 GMT

May be this set analysis within your expression

{<Invoice = e({<Material = {'A','X','Y','Z'}>})>}