Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI Daniel,
You can add another value with comma separator.
=Count({<Prod={'TH'}, SupC -={698758, 698452} >} If(SupA=SupB, Mat))
Hi, you can try with =Count({<Prod={'TH'}>} If(SupA=SupB, Mat))
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
HI @Daniel1908
Try like this
=Count({<Prod={'TH'}, SupC -={698758} >} If(SupA=SupB, Mat))
Hi Mayil,
Thanks for your help.
How can I exclude another SupC? 698758 and 698452?
Kind Regards,
Daniel
HI Daniel,
You can add another value with comma separator.
=Count({<Prod={'TH'}, SupC -={698758, 698452} >} If(SupA=SupB, Mat))
Hi Mayil,
Thanks for your help.
Kind Regards,
Daniel