calculation distinct

[#1]

Hi

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

Thank you

[Anonymous]

A Straight Table with :

• Dimension    document
• Expression  = Count (  distinct branch )

Will give the count of ranches for each document.

You can select document2 if that is the only one you wish to see.

[awhitfield]

Hi Marina,

see the additional table in the attached.

HTH

Andy

[#4]

It is not exactly

[HirisH_V7]

Hi,

May be like this,

Dimension:

branch

Expression:

=Count(DISTINCT{<document={'document2'}>}document)

Hope this helps,

PFA,

Hirish

[#6]

I'm looking for the number of branches that do not have a document 2

[#7]

[HirisH_V7]

Hi,

Check this,

Can you explain a bit more ! Your output required.

PFA

Hirish

[sasikanth]

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

[awhitfield]

Ha, that's not what you asked for though