Need help with set analysis

[#1]

I need help determining why I am not get any results for this set analysis below. 

SUM({$<[Est Cost], [Work Flow Doc Type] -= {'UE - *','CO *', 'CM*'}>} DISTINCT [WO ID])

I am trying to get the total for the estimated cost of planned work orders.  I am getting 0 right now.

[ToniKautto]

Try the expression partially as below to see if you can identify the failing part. If this doesnt give you any clues, please proivde a sample QVW so that the chart object can be evaluated.

SUM(DISTINCT [WO ID])

SUM({$<[Est Cost]>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'UE - *'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'CO *'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'CM*'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'UE - *','CO *'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'CO *', 'CM*'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'UE - *', 'CM*'}>} DISTINCT [WO ID])

[jduenyas · Accepted solution]

Try:

SUM({$<[Work Flow Doc Type] -= {'UE - *','CO *', 'CM*'}>}[Est Cost])

[#4]

Thanks so much.  I appreciate your quick response.