Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
what shall I do to make it display only S1, and S2 regardless of any selection made
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
no i tried this already it gives wrong results
look can you help me in the disucussion titled help in expression
let's ignore this part