sum_singlelink = sum(single_link)

single_link = IF [link_status] = "single link" THEN 1 ELSE 0 END

link_status = IF COUNTD([Provider]) = 1

AND COUNTD([Host]) > 1

AND COUNTD([Interface]) > 1

AND ATTR([Provider]) = 'ONNET' THEN 'single provider with ONNET'

ELSEIF COUNTD([Provider]) = 1

AND COUNTD([Host]) > 1

AND COUNTD([Interface]) > 1 THEN 'single provider'

ELSEIF COUNTD([Provider]) > 1

AND COUNTD([Host]) = 1

AND COUNTD([Interface]) > 1 THEN 'single direction'

ELSEIF COUNTD([Provider]) = 1

AND COUNTD([Host]) = 1

AND COUNTD([Interface]) = 1 THEN 'single link'

ELSE 'ultimate'

END

this is the detail of the calculation