Skip to Content

Count of Scetion

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!



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Sep 07, 2016 at 07:37 AM

    Please Help 😔

    Add a comment
    10|10000 characters needed characters exceeded

    • 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



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.