Friday, March 23, 2012

Number of nonempty cells in a collumn

Hello!

How can I find "Totals" of rows with filled data?

E.g.:

Date1

Date2

Date3

Date5

Date6

Date7

date8

1-Jul-06

2-Jul-06

5-Jul-06

10-Jul-06

11-Jul-06

2-Jul-06

3-Jul-06

6-Jul-06

11-Jul-06

3-Jul-06

4-Jul-06

7-Jul-06

12-Jul-06

4-Jul-06

5-Jul-06

8-Jul-06

5-Jul-06

6-Jul-06

9-Jul-06

6-Jul-06

7-Jul-06

7-Jul-06

8-Jul-06

9-Jul-06

10-Jul-06

Totals:

10

6

5

3

1

0

0

The datasource is an XML file, and I cann't get tatals from it...

Put this in the group footer:

SUM(IIf( IsNothing( Fields!IDate1.Value), 0, 1))

|||Thank you very much, John!

No comments:

Post a Comment