I have an expression that looks like this:
=COUNT(TOTAL {< patient_region=E({<patient_region={'$(vCurrentRegion)'}>}), patient_province , admission_category >} patient_id)
This should calculate the total number of cases excluding the cases in the current region selected. For some reason it is still counting the cases in the current region. Is there anything wrong with my set analysis?
You can do without E.
=COUNT(TOTAL {< patient_region-={'$(vCurrentRegion)'}, patient_province , admission_category >} patient_id)