Calculated column count

[Hanzelmans]

I have a master-child list report where I would like to calculate a count of certain rows in the child list.

The child list contains a student name/status/etc. I would like to calculate the total number of students in a course that have a status of "Complete".

I've tried various things, but can't seem to get it to total that correctly.

Any ideas would be great. Thanks!

Steve Hanzelman
Milton Hershey School

http://www.mhs-pa.org

 

[blom0344]

Try: define [#COMPLETE]

CASE
WHEN
[STATUS] = 'Complete'
THEN (1)
ELSE (0)
END

Then define second calculation:

total ([#COMPLETE] for [course])

Ties Blom

 

[Hanzelmans]

Ties,
Thanks. That worked perfectly.

Now for the follow-up question: is it possible to total those totals to get a master figure of all 'Complete' students?

I have tried a few things, but it looks like it doesn't want to allow a total from the detail query be displayed in the master query.

Thanks,
Steve

Steve Hanzelman
Milton Hershey School

http://www.mhs-pa.org

 

[blom0344]

Where do you want to display the grand total? Depending on which version you are on this might be a suitable case for a singleton. Singletons should have the benefit of being able to be placed everywhere in the report..

Ties Blom