Looping formulas in a table 1

[sijeffs]

Hi All,

Be very grateful if someone can give me some pointers as my looping skills are woeful.

I have a table that I need to report from that represents our Orgs structure. The table contains a row for every position in the org and the rows contain details of the position as well as the Parent Position Id and a value for the number of branches down the structure the position is.

What I need help on is a Formula to keep looping through the table using the Parent Position Id and Id to move up through the positions until it gets to a definable branch say "5" and then return the details of that level so I can group on it.

If anyone can point me in the direction of some useful resources or an example I'll be eternally grateful.

Regards

Sijeffs

 

[LidoDeJesolo]

If I understand the question correctly, it sounds like you could do this using hierarchical grouping options in your Reports drop-down.

In CR 8.5 it's a wizard tool. If you need further explanation of this then let us know which CR version you are using and the field names of the data you are manipulating.

Lido
Development & Reporting
UK