Skip to Content
0
Former Member
Feb 20, 2006 at 10:38 AM

Excel Formula instead Bex Formula Editor in NW04S

24 Views

dear all, I have a question about query builder:

if with the query builder the user builds a report (with a fixed structure) like the following with a formula on the third row (with the formula builder) can the user see, in the screen when they run the query, this formula as an excel formula?

Row Column

Row 1 (selection) Company = ‘A’

Account = ‘AB’

Row 2 (selection) Company = ‘A’

Account = ‘AB’

Row 3 (formula) Row 1 + Row 2

The resulting report should have the following values:

Row Result (column A)

Row 1 (selection) 100 €

Row 2 (selection) 50 €

Row 3 (formula) 150 €

Clicking on Row 3(formula) they would like to see the Excel formula A1+A2 (settled in the query with the Bex formula editor)

Thanks in advance and best regards,

Mauro