help in set analysis

[ali_hijazi]

got the following expression

count

(
{

<

UNIQUENESS={1}

,BACKPORTED_FLAG={'Y'}

,H_Product_Type={'MX3'}

,DEFECT_SEVERITY_ID={'S1','S2'}

>

} MR_KEY_VERS_DEF_ID)

+

SUM({$} IF(DEFECT_DETECTION_PHASE='PRE_RELEASE',AGGR(COUNT({

<

UNIQUENESS={1}

,BACKPORTED_FLAG={'Y'}

,H_Product_Type={'MX3'}

,DEFECT_SEVERITY_ID={'S1','S2'}

,DEFECT_DETECTION_PHASE={'POST_RELEASE'}

>

} MR_KEY_VERS_DEF_ID),FIX_PERIOD, RELEASE),0))

why would the second part be affected by the selection of a severity value S1, and S2

please advise

[alexandros17]

Because you are counting with the condition DEFECT_SEVERITY_ID={'S1','S2'} that is all the records includint these 2 values. If you select only S1 for example then you will restrict the result.

[ali_hijazi]

what shall I do to make it display only S1, and S2 regardless of any selection made

[alexandros17]

Try this:

...

+

SUM({$} IF(DEFECT_DETECTION_PHASE='PRE_RELEASE' and (DEFECT_SEVERITY_ID='S1' or DEFECT_SEVERITY_ID='S2' ),AGGR(COUNT({

<

UNIQUENESS={1}

,BACKPORTED_FLAG={'Y'}

,H_Product_Type={'MX3'}

,DEFECT_SEVERITY_ID=

,DEFECT_DETECTION_PHASE={'POST_RELEASE'}

>

...

Let me know

[ali_hijazi]

no i tried this already it gives wrong results

[ali_hijazi]

look can you help me in the disucussion titled help in expression

let's ignore this part