Hi Kenosha,In order to calculate a custom field value the selections that will make up the calculation must first be included in order to populate the field list in the Custom Fields definition - these fields do not need to be used in the output, however the usual T-SQL rules around grouping of selected columns will apply. For your specific case, you can use two different ways to assign the “Abandoned” value to each record.You may use the CASE function, or the IIF function - examples of both options are below. CASECASE WHEN (Inbound_sys_INBOUND_CALL_RING_TIME >= 1 AND (Inbound_sys_INBOUND_CONNECTED_CALL_DURATION = 0 OR Inbound_sys_INBOUND_CONNECTED_CALL_DURATION IS NULL)) THEN 1 ELSE 0 END IIFIIF((Inbound_sys_INBOUND_CALL_RING_TIME >= 1 AND (Inbound_sys_INBOUND_CONNECTED_CALL_DURATION = 0 OR Inbound_sys_INBOUND_CONNECTED_CALL_DURATION IS NULL)),1,0)
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
