Row Count

[Former Member]

My report is made up of several column, none of which are fully populated, how can I get a count of how many entries there are in my report? Every time I do a count of a specific column it does not count the blank entries so doesn't reflect the number of rows. I need a running count and final count as my report is hundreds of pages long.

[Former Member · Accepted solution]

if it is a webi report use the below forumla =Count([any object name]; IncludeEmpty)

it will also count blank rows

[Former Member · Accepted solution]

Thanks for that. How do I get the total count of the rows onto the first page of the report?

[Former Member · Accepted solution]

You have two options:

1. Use Free-Standing cell and drop the Formula in that. (You can place it where ever you need)

2. Create Variabe as "Count" and place the formula in that.

Hope it works for you.

Thank You!!

[Former Member · Accepted solution]

I dropped it into 'free space' and it's giving me a different figure to the final count of all the rows (3000 less)

[Former Member · Accepted solution]

Can you post me the formula??

Try this:

=Count(<Object Name>;IncludeEmpty;ALL) In Report

Thank You!!

[Former Member · Accepted solution]

This the formula I dropped into a free cell that returned 3000 less rows than the count

=Count([NHS Number]; IncludeEmpty)

I tried the formula:

=Count([NHS Number];IncludeEmpty;ALL) In Report

But that returned roughtly 50,000 more rows than the count.

[Former Member · Accepted solution]

Try this:

Remove ALL :

=Count(<Object Name>;IncludeEmpty;DISTINCT) In Report/Block

=Count(<Object Name>) In Report/Block

Or

=RunningCount(<Object Name>;IncludeEmpty)

=RunningCount(<Object Name>;IncludeEmpty) In Report/Block

Thank You!!

[Former Member · Accepted solution]

Hi,

=Count(<Object Name>;IncludeEmpty;DISTINCT) In Report/Block - The incorrect number didn't change to the correct one

=RunningCount(<Object Name>;IncludeEmpty) - The number changed to 1

I think I must be doing something wrong.

[Former Member · Accepted solution]

in the report select any object and select count. it should create a row at the end of the report. select that cell and modify the formula to include additional parameters. this shoule work

[Former Member · Accepted solution]

Are you successful or still facing any issues?? Pls update...

Thank You!!