Hi,
i want to find count of lender offer id's who are not involved in survey completed, certificate downloaded and click with logtype id = 23 from cousecompleted lender offer ids.
Below is the code i have used
count({
<lender_offer_id -= {"=count({$< final_test_status={'Passed'},course_completed={'1'},certificate_download_count = {'>0'} >}distinct lender_offer_id)"}>
*
<lender_offer_id -= {"=count({$<log_type_id={'23'} ,final_test_status={'Passed'},course_completed={'1'}>}distinct lender_offer_id)"}>
*
<lender_offer_id -= {"=count({$<survey_completed={'1'},course_completed={'1'},final_test_status={'Passed'}>}distinct lender_offer_id)"}>
}
distinct lender_offer_id)
But above query gives wrong Number, Correct number should be 22.
and see attached qvf file
