I suggest Structure should ...

provide "root element of column x" in the variable selection list of formula column editor

E.g. to calculate a percentual distribution over all rows of a structure, for the formula you need the 100% value which is typically shown on the root element.

Therefore it would make a lot of sense, to be able inside "formula column A" to use a columns B's value, but the root element value! This should be possible even if column B is a formula itself.
As we can already use variables like "Column B ..." in formulas it would be nice to add "Root Value of Column B ..." to the variable selection list

3 votes
Sign in
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
Sign in with: facebook google
Signed in as (Sign out)
  • AdminStructure Team (Admin, ALM Works) commented  ·   ·  Flag as inappropriate


    It is possible to use root issue for each "sub-hierarchy". Let's say you have structure
    - IssueB
    - Issue C

    and no other issue on the same level with IssueA and would like to use the Issue A value. In this scenario you can create separate formula column, just to "get" the root value, with formula like "parent#depth=1{f}". (depth = 1 is the root level, if automation mode is switched off, f - you formula column A). But in this example, if you have other issue in stryucture, their root will be used, not IssueA.

    Will it help? Please do not hesitate to ask if you have any questions!

    ALM Works Team

Feedback and Knowledge Base