Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How to count the number of ranches in which there document.2 ?
Thank you
But I added + 1 branch. and now in the table should be "2"
hi
Try this expression
= count(DISTINCT aggr(count( if(document<>'document2', branch)),branch))
removed DISTINCT inside aggr, just try it.
Pls. see attachement
Thank you |
count( {<Column name={'Name'}>}Distinct Documnent2)