Counting columns with 2 conditions

[abhi1693r]

I am trying something like 

=(Count( DISTINCT {<A={"SD"}>}{<B={"TD"}>} A&'|'&B))

A and B are in different tables joined by LEFT JOIN

And I noticed that only A=SD condition is applying but B=TD is NOT.

Is there a way to implement both conditions together with 'OR' logical operator??

[Ezirraffner]

Try this

=Count(  {<A={"SD"}>+<B={"TD"}>}  DISTINCT A&'|'&B )

[abhi1693r]

Nope, Doesn't work 😕

[Ezirraffner]

Represent the current selection:

=Count(  {<A={"SD"}>+<B={"TD"}>}  DISTINCT A&'|'&B )

Represent the full set of data associated :

=Count(  {1<A={"SD"}>+1<B={"TD"}>}  DISTINCT A&'|'&B )

[abhi1693r]

Can I use it like this,

=concat({<A={"SD"}>+<B={"TD"}>}  DISTINCT A) &'|'& concat(B)

and now count it somehow.

I am not familiar with how to count concatenated string.

But this should work right?

PS: Please correct the syntax if req

[Ezirraffner]

Concat function returns the aggregated string concatenation of all values of the expression iterated over a number of records as defined by a group by clause.

Could you upload a sample that expected result?