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!!

[Former Member]

OK, I have this in a box at the top of my report.

=Count([Metric Name]; IncludeEmpty;All) in Report

And it returns the number of rows in the ENTIRE report. 8,944

HOWEVER

We use about 9 "Input Controls" as filters for the data and the formula above does not change.

What tweak do I need to do to the formula to make it sensitive to the input control selecton?

Thanks

David

[Former Member]

Thanks for all your input. All the counts worked when new data was loaded into the universe.

[Former Member]

Hi LSmith,

To get the number of rows, try with this formula in your variable Editor.

=NumberOfRows([Object])

You can place this formula anywhere in your report.

Hope it works for you.

Thanks,

Swathi.

[Former Member]

Count() will not give exact figure.

Eg:

Data

-

---

10

10

20

30

40

40

50

50

---

=Count([Data]) --- Results: 5 -- Which is not correct.

To get all the counts and null rows/columns, Use the below formula:

Syntax

=Count([object]; [INCLUDEEMPTY]; [DISTINCT or ALL])

Thank You!!