AnsweredAssumed Answered

URGENT HELP req for a count

Question asked by beckett85_1 on Sep 30, 2009
Latest reply on Oct 1, 2009 by skn

Title

URGENT HELP req for a count

Post

i need a way to count the number of related records, but set to a certain value

my situation is:

 

i have projects, each has related jobs, i need to count the number of jobs complete, and jobs pending payment

 

thus i need something like

 

count(jobs::status="complete") and count(jobs::status="pending payment")

 

is there any way that you can count through this requirement or do i need to create multiple portals?

 

thanks heaps, any ideas would help as this is mega urgent

Outcomes