Skip to Content
0
Former Member
May 03, 2018 at 05:55 AM

Combination of values of two infoobjects in query designer - possible?

155 Views Last edit May 04, 2018 at 06:03 AM 2 rev

Have two columns:

Pno Dno Quan

311 45 1000

311 40 2000

641 45 3000

551 40 4000

I want to have only the combination of row 1,3 and 5 (sum of Quan is 8000) extracted in a Query, but I have Challenges on how to do this directly in the Query without making a CONCAT Field in the ADSO.

Any idea how I should do this?