Skip to Content
0

VLOOKUP equivalent in SAP WEB Intelligence

Jul 25, 2017 at 09:14 AM

129

avatar image
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.

10 |10000 characters needed characters left characters exceeded

can you share some sample data

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Jul 25, 2017 at 01:42 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded