3 Replies Latest reply: Mar 15, 2012 6:04 PM by Shedrick Pugh

# Need help with set analysis

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.

• ###### Need help with set analysis

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])

• ###### Need help with set analysis

Try:

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

• ###### Need help with set analysis

Thanks so much.  I appreciate your quick response.