Dear Experts,
I am trying to count from two different fields with criteria but it gives me an error
I want to select 2020 from Field Name1 and count if greater than 0 from Field Name2
Table Name : SUMMARY QAFAM 2020
Field Name1: RP expiry year
Field Name2: RP RENEWAL
I am using this formula but its not working.
=DCount("SUMMARY QAFAM 2020","[RP expiry year] = '2020'","[RP RENEWAL]>'0'")
Rgds,
AB