Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try:
SUM({$<[Work Flow Doc Type] -= {'UE - *','CO *', 'CM*'}>}[Est Cost])
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])
Try:
SUM({$<[Work Flow Doc Type] -= {'UE - *','CO *', 'CM*'}>}[Est Cost])
Thanks so much. I appreciate your quick response.