Dear all, I am looking for a solution to count and list cases that do NOT find a related information in an additional table but do have the status "A50".

Hi,

I am not an expert (I mean some PQL really basic knowledge) therefore for sure there are better solutions.

Nevertheless a solution that works is using Pull functions, the PU_COUT.

FILTER PU_COUNT ( "CASE TAB", "DIMENSION TAB"."CHECK") = 0 AND "CASE TAB"."STATUS" = 'a50'.

Hope it helps.

Javier

Dear Javier,

many thanks for your information. I tried your code in a number component but there was no result for ("CASE TAB", "DIMENSION TAB"."CHECK") = 0 . Obviously it seems to be a problem to get an indication/count of cases when a specification (KEY CHECK does not exist) is true.

True means ( !='' or Null or =0).

best regards

Stefan

Hi Stephan,

I built a small analysis to showcase the question, I've recorded a !quick and dirty video". Hope it helps

Javier