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
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • AdminStructure Team (Admin, ALM Works) commented  ·   ·  Flag as inappropriate

        Hello,

        It is possible to use root issue for each "sub-hierarchy". Let's say you have structure
        IssueA
        - 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!

        Julia,
        ALM Works Team

      Feedback and Knowledge Base