BW Query Table: How to work with two columns

[Former Member]

Hi all,

can anybody help me with following problem?:

I added a field (input field) to a existing table -> column4. Is it possible to

calculate column 2 + column3 in dependency of column 1 ????

The result should then be written in my new field (column 4).

Example:

Col. 1_______Col. 2_______Col. 3______Col.4

A___________5__________6__________11

B___________3__________2__________5

C___________4__________2__________

In this example the calculation is only made when Col. 1 is A or B ????

Thanks for any help, best regards

Frank

[Former Member · Accepted solution]

Hi Frank,

you should use an expression box instead of an input field. Then insert a formula like:

if(@column1==A OR column2==B, column2+column3, '')

Maybe you have to cast the column 2 and 3 so that you can compute the value for column 4.

Best Regards,

Marcel

[Former Member · Accepted solution]

Hi Marcel,

thanks, that is the solution. I was not able in the control properties to see the

field expression. But with TAB it was possible to make an entry

Thanks a lot, best regards

Frank