Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Local formula in rows

Hello BW Experts,

I wanted to know if there is a way to use a local formulas in Rows: i need to insert a row with a formula who adds/substracts other rows in a table.

I am using a hierarchy so i can not do that in the Query Designer.

Thanks in Advance,

Raffi

Former Member
Former Member replied

Hello BW Experts,

I wanted to know if there is a way to use a local formulas in Rows: i need to insert a row with a formula who adds/substracts other rows in a table.

I am using a hierarchy so i can not do that in the Query Designer.

->

Even if you are using Hierarchy you can subtract rows, for that you have to use structures,

Structures-> slection-> new selection>restrict your hierarchy nodes one in each element

Structure-> new formula-> subtract your Structure elements (rows)

For example if you have Region as your hirarchy and nodes are GA, TN, FL

you can create 3 new selections, restrict Regions to GA, TN, FL respectively

in the formula you can subtract GA- FL

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question