topic Re: Compare same text in three columns and count a different one in App Development

Compare same text in three columns and count a different one

Daniel1908 — Fri, 26 Mar 2021 15:47:52 GMT

Hello Together,

I am looking for a solution to compare the same text in three columns and count a different one.

For example:

If= Supplier A is equal to Supplier B and Product Key is "TH" count Material

Thanks for your help.

Kind Regards,
Daniel

rubenmarin — Sat, 27 Mar 2021 08:11:03 GMT

Hi, you can try with =Count({<Prod={'TH'}>} If(SupA=SupB, Mat))

Daniel1908 — Mon, 29 Mar 2021 07:54:20 GMT

Hi,

that worked, thanks for your help.

How can I exclude a text from a column?

For example exclude 698758 from column Supplier C.

Kind Regards,
Daniel

MayilVahanan — Mon, 29 Mar 2021 08:52:34 GMT

Try like this

=Count({<Prod={'TH'}, SupC -={698758} >} If(SupA=SupB, Mat))

Daniel1908 — Mon, 29 Mar 2021 09:41:18 GMT

Hi Mayil,

Thanks for your help.

How can I exclude another SupC? 698758 and 698452?

Kind Regards,
Daniel

MayilVahanan — Mon, 29 Mar 2021 09:49:02 GMT

HI Daniel,

You can add another value with comma separator.

=Count({<Prod={'TH'}, SupC -={698758, 698452} >} If(SupA=SupB, Mat))

Daniel1908 — Mon, 29 Mar 2021 09:54:41 GMT

Hi Mayil,

Thanks for your help.

Kind Regards,

Daniel