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
hi
Try this expression
= count(DISTINCT aggr(count( if(document<>'document2', branch)),branch))
removed DISTINCT inside aggr, just try it.
Pls. see attachement
A Straight Table with :
Will give the count of ranches for each document.
You can select document2 if that is the only one you wish to see.
Hi Marina,
see the additional table in the attached.
HTH
Andy
It is not exactly
Hi,
May be like this,
Dimension:
branch
Expression:
=Count(DISTINCT{<document={'document2'}>}document)
Hope this helps,
PFA,
Hirish
I'm looking for the number of branches that do not have a document 2
Hi,
Check this,
Can you explain a bit more ! Your output required.
PFA
Hirish
HI,
try this Expression for Branches that do not have Document 2
= count(DISTINCT aggr(count(DISTINCT if(document<>'document2', branch)),branch))
Please find the attachment
Ha, that's not what you asked for though