Sum of conditional count of records

[#1]

Greetings;

I have a one-to-many parent-child table relationship.  Incident tickets are in the parent table, incident comments are in the child table.

I want to count the incidents by quarter, which have at least one comment [child] record.

There is a straight table with dimensions of Incident number and quarter start of the Incident create date.

The expression I'm attempting is this:  sum( if ( count ( Comments ) > 0,1,0) ) 

And it works without the sum - using only the "if" shows a 1 and a zero just fine.  it's when I try to add them by quarter that I get no results.

Any help is appreciated.

Thanks,

[Jason_Michaelides · Accepted solution]

Try this:

Count({<IncidentNo={"=Count(CommentNo)>0"}>}DISTINCT IncidentNo)

See attached.

Hope this helps,

Jason

[#3]

That worked!  Thanks also for setting up that whole example file.

Now another question, where is the definition of the quarters in that nifty format - "Jan-Mar 2011"  ?

Thanks again!

[Jason_Michaelides]

QuarterName(DateField) in the script.

[#5]

Thanks!