calculation distinct

[#1]

Hi

How to count the number of ranches in which there document.2 ?

Thank you

[#2]

HI,sasikanth_Narne

But I added + 1 branch. and now in the table should be "2"

[sasikanth · Accepted solution]

hi

Try this expression

= count(DISTINCT aggr(count( if(document<>'document2', branch)),branch))

removed DISTINCT inside aggr, just try it.

Pls. see attachement

[#4]

Thank you

[Anonymous]

count( {<Column name={'Name'}>}Distinct Documnent2)