Skip to Content
avatar image
Former Member

VLOOKUP equivalent in SAP WEB Intelligence

I have a data material which are sold in kits. For example a kit contains 10 parts. So if one quantity is sold then this means 1*10= 10 parts are sold. Every kit is of different bundles. How can I Vlookup in Web I, so that the part number is looked into another table and the corresponding multiplier is multiplied with the quantity.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 25, 2017 at 01:42 PM

    hi,

    you can merge query results.

    query result1

    material quantity unit

    A 1 kit

    query result 2

    unit number

    kit 10

    in webi merge query1 and query 2 via unit.

    add merged unit in your report and multiple quantity by number

    Add comment
    10|10000 characters needed characters exceeded