Skip to Content
avatar image
Former Member

how to create a variable on Bex Query Designer

Hello Experts,

I have been assigned to create a query which should include several restrictions. Our data includes several areas such as material number, creation date, QA status, KK status, source system and serial number. My objective is to make a query which should include QA, KK, date and material number. However, my supervisor wants to see the breakdown of the material by serial number but not serial numbers itself. The query should just show how many of the same material there are so we can manage the stock efficiently. I have found out that I need to create a variable but I cant figure out how to design it to work for me. I am including several screenshots of the project so all of you can understand it better. My programs are in Turkish. Tarih is date. If there is anything you dont understand, feel free to ask.

Best regards

Kaan

ss-1.png (38.7 kB)
ss-2.png (39.7 kB)
ss-3.png (59.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 22, 2016 at 01:27 AM

    Hi,

    Sorry I did not understand your requirement. Can you post a screen of your DESIRED RESULT? I think SS3 is not your desired output, right?

    I did not understand this:

    The query should just show how many of the same material there are so we can manage the stock efficiently.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      You may drag the MATERIAL NUMBER in your ROWS section then create a FORMULA in the COLUMNS section, just enter 1..Under the aggregation tab, choose SUMMATION with reference characteristic to MATERIAL NUMBER..

      Regards,

      Loed