topic Re: Concatenate two fields from different columns and exclude in App Development

Concatenate two fields from different columns and exclude

Daniel1908 — Thu, 01 Apr 2021 14:03:03 GMT

Hello Together,

I want to concatenate two fields from different columns and exclude.

Exclude Return Label C with Material 6TZ8*

=Count({<[Price]*={"<=100"},Productkey={'TH',"LR"},[ReturnLabel.]-={'A','B'}, Material= {"6*"}>*(1-<[Request]={"*"}>)}[Product Number])

Thanks for your help.

Kind Regards,
Daniel

Re: Concatenate two fields from different columns and exclude

jwjackso — Thu, 01 Apr 2021 14:22:53 GMT

Check the E() function

Re: Concatenate two fields from different columns and exclude

Daniel1908 — Thu, 01 Apr 2021 15:29:43 GMT

Can you give me an example how to use the E function in the formula?

Exclude Return Label C with Material 6TZ8*

=Count({<[Price]*={"<=100"},Productkey={'TH',"LR"},[ReturnLabel.]-={'A','B'}, Material= {"6*"}>*(1-<[Request]={"*"}>)}[Product Number])

Re: Concatenate two fields from different columns and exclude

jwjackso — Thu, 01 Apr 2021 15:39:44 GMT

I used [Product Number]=E(), you will need to use a field that is unique to the record.

=Count({<[Price]*={"<=100"},Productkey={'TH','LR'},[Product Number]=E({<[ReturnLabel={'A','B'},Material={"6*"}>}[Product Number])>}[Product Number])

Re: Concatenate two fields from different columns and exclude

Daniel1908 — Thu, 01 Apr 2021 17:38:34 GMT

I tried to use as below, unfortunately without success.

Any Ideas?

=Count({<[Price]**={"<=100"},Productkey={'TH','LR'},[Returnlabel]-={'A','B'},
Material= {"6*"},Material&Shorttext=E({<[ReturnLabel]={'C'},[Group]={"V231"}>}Material&Shorttext)>},Material&Shorttext)>*(1-<[Request]={"*"}>)}Material&Shorttext)

Re: Concatenate two fields from different columns and exclude

Daniel1908 — Fri, 09 Apr 2021 09:51:41 GMT

Hello Together,

does any one have an idea why Material-={"1RK3*"} doese not work?

=Count( {<Preis]*={"<=100"},Productkey={'TH', 'LR'},[Returnlabel]-={'A','B'}, Material= {"1*"},Material-={"1RK3*"}>*(1-<[Request]={"*"}>)}Material&Shorttext)

Kind Regards
Daniel

Re: Concatenate two fields from different columns and exclude

jwjackso — Fri, 09 Apr 2021 13:22:28 GMT

Try replacing Material={"1*"},Material-={"1RK3*"} with

Material=P({<Material={"1*"}>}Material)*E({<Material={"1RK3*"}>}Material)

Which should be an intersection of records where Material = "1*" and Material <> "1RK3*"

Re: Concatenate two fields from different columns and exclude

Daniel1908 — Mon, 12 Apr 2021 07:42:40 GMT

Thanks a lot that worked.

Kind Regards
Daniel