count function

how to write a count function for this

Count All Agreement Settlement Tasks Where Settlement Action IS ATTEMPT AND Process Date is today


saibaba143 (BOB member since 2010-06-26)

Something like the below should be a good start.

=Count([Agreement_Settlement];All) Where([Settlement_Action] = "ATTEMP" And [Process_Date] = CurrentDate())

plessiusa :netherlands: (BOB member since 2004-03-22)