AnsweredAssumed Answered

Complex value count

Question asked by beckett85_1 on Oct 5, 2009
Latest reply on Oct 6, 2009 by philmodjunk

Title

Complex value count

Post

ok at the moment i have a formula

 

ValueCount ( FilterValues ( List ( Jobs For Projects::STATUS ) ; "complete¶completed, pending payment" ) )

 

Counds the related records in a project where by the status is "complete" or "completed pending payment"

 

is it possible to extend the count to add in job type so in my jobs table i will have Status As wel as type

so if there are two jobs under the type 'kitchen' and 1 contains 'complete' it would return 1

 

thanks in advance

Outcomes