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 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