cancel
Showing results for 
Search instead for 
Did you mean: 

Local formula in rows

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks a lot it works!

Answers (0)