How do you count a column's values in IM 5.0?

Let's say I have a computed "daysafter" column for two dates. In the

Summary, I want to count the number of rows that contain certain values, for

example:

Computed column values:

1

2

2

5

1

0

Summary (This is what I want):

0-1 days late: 3

2-3 days late: 2

4 or more days late: 1

So...how would I write the expression for these three computed fields in the

Summary section? Thanks.

There may be an easier way, but I usually do this in two steps, i.e. create

a computed field in the detail that returns either a 1 if it meets the

criteria or a 0, and then sum that computed field in the summary. You can

set the visible property on your computed fields to 0 so they do not

display.

In your example I would have three computed fields in the detail:

count_a = if( your_column <= 1, 1, 0)

count_b = if( your_column >= 2 AND your_column <= 3, 1, 0)

count_c = if( your_column >= 4, 1, 0)

The summary would have sum(count_a), sum(count_b), and sum(count_c).

Rick Marden

Primavera Systems, Inc.

Rick's method is probably the easiest. The problem is really that you are

limited to a predefined number of computed fields. If you don't know home

many computed fields you will need, you will have to go to a nested report

that does the summarizing. The downside of that is that you essentially run

the same SQL twice.

--

Terry Dykstra (TeamPS)

Canadian Forest Oil Ltd.

I've done some research, and found that I could get this total by grouping

and then entering the count calculation in the Trailer group area.

BUT, I want all the totals at the bottom of the page, and no groups. Why

isn't a simple calculation working, i.e. count (computed field = 1). I want

the summary section to count how many rows' computed fields equaled 0 to 1,

and then 2 to 3, for example. Any suggestions?