Set Analysis - Only Associated Data From Another Field?

[Anonymous]

Hello,

I'm pretty new to QV, and very new to set analysis.

Sum({$<[Cost Elem._COST_ELEM.FAGLFLEXA] = '90360100' and [Cost Ctr_KOSTL.BSEG] = {*} - {' '}>} Values)

I want to sum [Values] where [Cost Elem._COST_ELEM.FAGLFLEXA] = ‘90360100’ AND (+?) only [Cost Ctr_KOSTL.BSEG]’s relevant (associated) values are selected. There’s a one to many relationship between Cost Elem and Cost Ctr (1 cost elem to many cost ctrs) when a cost elem is selected. Is it even possible to just select the associated cost ctrs? Should I just list them out instead? The expression box bug won't compile/validate the rest of the expression for me. I want to make sure it’s good 1^st because I have others to write based off of it.

[simenkg · Accepted solution]

Sum({$<[Cost Elem._COST_ELEM.FAGLFLEXA] = {90360100}, [Cost Ctr_KOSTL.BSEG] -=  {' '}>} Values)

[#3]

Hi,

Try this

Sum({$<[Cost Elem._COST_ELEM.FAGLFLEXA] = {90360100}, [Cost Ctr_KOSTL.BSEG] = {*} - {' '}>} Values)

[Anonymous]

Will report my findings and will be sure to credit the responses as correct when I find out. Thanks a lot for your help you guys.