cancel
Showing results for 
Search instead for 
Did you mean: 

Count

Former Member
0 Kudos

Hi,

I have a webi report wherein I have a section and a break applied to two different columns.

The requirement is such that I need to show the count of all the rows on the report.

I applied count function on a numeric field and I am getting counts by the column on which I have applied break and also it sums up by the coulmn on which section is applied

However I need the total count of the rows on the report. Outside the section when I apply the count function on the numeric column it does not give me total no of rows on the report.

I did try applying the sum function on the count but to no success.

Please let me know if there is a way to achieve the count of total number of rows on the report which contains a section as well as a break.

Thank You,

boe user

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You need to use context.

example

Table

State / Lines/ Sales Revenue

Break in State

and apply this formula to count the lines.

=Count([Lines];All) ForAll([State])

Regards.

Yudel Vives

Former Member
0 Kudos

Yes the count for all rows is possible. Use formula

 Count([Object Name];All) In Report 

Regards,

Rohit