Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Its best to flag these records as part of the script.
try with
sum({$<CALL_STATE={Closed},IPK_STATUS={Incident},ACTION_COUNT=-{1}> + <CALL_STATE={Closed},IPK_STATUS={Problem},ACTION_COUNT=>}
INLIMIT)
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
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)
Thanks Massimo for your help. It worked like i needed.