VLOOKUP equivalent in SAP WEB Intelligence

[Former Member]

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.

[former_member199945]

can you share some sample data

[kohesco]

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