Skip to Content
0
Jan 17 at 01:18 PM

If then else not working to label an element

120 Views

For example I have the following table

Invoice||Article ID||Article type||Number||Cost per unit||
IN001  ||      1001||     Service||     2||        75.00||
IN001  ||      1011||       Goods||     5||        15.00||
IN001  ||      2001||       Goods||     6||        20.00||
IN002  ||      1011||       Goods||     1||        15.00||
IN003  ||      1001||    Services||     2||        75.00||

I want to make a table in WEBI which shows the following:

Invoice||Remark
IN001  ||Goods & Services
IN002  ||Goods only
IN003  ||Services only

I tried to solve this with If then else and For Each statements, but I always receive an #MULTIVALUE as a result.

Is there any way to solve this?