Complex value count
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