IF condition in a set analysis ?

[#1]

How do i write following IF condition in set analysis.

Sum(If(Match(CALL_STATE,'Closed') and ((IPK_STATUS ='Incident' and ACTION_COUNT <> '1')or Match(IPK_STATUS,'Problem')) ,INLIMIT))

Thanks,

Naveen

[srchilukoori]

Its best to flag these records as part of the script.

[maxgro]

try with

sum({$<CALL_STATE={Closed},IPK_STATUS={Incident},ACTION_COUNT=-{1}> + <CALL_STATE={Closed},IPK_STATUS={Problem},ACTION_COUNT=>}

INLIMIT)

[#4]

Hi Massimo,

Thanks for your reply. Your solution works but If I select "Incident" , it also counts"Problem" in the resultset. How do i show only based on current selections.

Thanks,

Naveen

[maxgro · Accepted solution]

see attachment, my expressions are compared to your original expression

sum({$<CALL_STATE*={Closed},IPK_STATUS*={Incident},ACTION_COUNT=-{1}> + <CALL_STATE*={Closed},IPK_STATUS*={Problem},ACTION_COUNT=>}

INLIMIT)

[#6]

Thanks Massimo for your help. It worked like i needed.