Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 07 at 09:09 AM

    Hi

    if Dno always should represent the highest value, this is what you can do

    create a formula -> create a formula variable in it, set as replacement path of Dno -> add condition to the query, set as top 1 of the formula and assign only Dno as reference.

    Now only the line:

    311 45 1000

    should remain

    grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 14 at 03:20 PM

    Hello Helge;

    I think you can do it using RFK but you will need variables for Pno and Dno.

    1. RFK with Qty and exclude value of Pno variable (RKF1)

    2. RFK with Qty and exclude value of Dno variable (RKF2)

    3 CKF with formula: IF (RKF1 = RKF2; RKF1 (or RKF2); MAX (RKF1, RKF2)

    The result should be something like this:

    Pno Dno Quan RKF1 <> 311 RKF2 <> 40 CKF

    311 45 1000 0 1000 1000

    311 40 2000 0 2000 0

    641 45 3000 3000 3000 3000

    551 40 4000 4000 0 4000

    Of course, remove Pno or Dno from the structure or multiple combinations to exclude will not work.

    Hope it helps;

    Regards

    Ricardo

    Add comment
    10|10000 characters needed characters exceeded