Count of Scetion

[former_member371433]

Hello All,

PFA attached scenario.

I have used following 3 columns in my report block:

          1. Case ID

          2. Match ID

          3. Case Status

I have applied Section on Case ID. Also have hide report block where Match_ID is -1 or if report block is empty.

Now, in upper cell (Out of section), I need to show the count of Total number of distinct Case ID:

Please let me know if I can provide any more details.

Please Help!

Thanks,

Kushal

[former_member371433]

Please Help

[amitrathi239]

have you tried =count([Case ID])

[former_member371433]

Hi Amit,

Thanks for relying

Yes, I have tried =Count([Case ID]).

It's giving me overall count of case id (including the Case ID which I have made hidden by applying formula Hide report block if Match_ID=-1)

I just want the Distinct Count of case id.

Thanks,

Kushal

[amitrathi239]

try this.

=Count([Case ID]) where (Match_ID<>-1)

[former_member371433]

Hello Amit,

Thanks a lot for replying.

I tried this formula but there are some Report block like given below:

Now here, one match ID is -1, hence I have made it hidden, Because I want only those report blocks where all the Match ID are not -1 as below.

Now if I apply formula =Count([Case ID]) where (Match_ID<>-1), it won't take first row of above 1st table but take 2 rows where Match_ID<>-1.

I have made it hidden, but I don't want count formula to include the data from hidden report blocks.

Please help

Thanks,

Kushal