AnsweredAssumed Answered

Complex value count

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


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