OTBI conditional count

Jaime Castillo

Hello,

My problem is the following: I would like to have a customized metric with that counts the number of learners that have "General Information"."Enrollment Record Substatus Code" <> 'ORA_ASSN_REC_NOTSTARTED' AND "General Information"."Enrollment Record Status Code" = 'ORA_ASSN_REC_ACTIVE' (counting everything less a subset).

The code that I used is basically this:

SUM(CASE WHEN ("General Information"."Enrollment Record Substatus Code"<>'ORA_ASSN_REC_NOTSTARTED' AND "General Information"."Enrollment Record Status Code"='ORA_ASSN_REC_ACTIVE') THEN 1 ELSE NULL END).

This is what I obtained (Result image):

The problem is that what is expected is different:

I attach the XML code in the attached .txt files for the "result" and "expectation" reports.

Any help or hint to correct this is welcome.

Kind regards.

Expectation.txt

Results.txt