Get previous data in repeat region

[ErikClacey]

I have a drawing with a repeat region. I now want one column to show the value of a cell in its row added to the value of the cell in the previous row, ie each row shows the sum of the prevous rows.

In Excel I'd do this like this:

Al values in Column A with the summations, using the formula below, in Column B

Cell(B2)=Cell($A2) +Cell(B1)

Pulling this down the column B will take the row value of column A and add it to the above value of column B, thus totalling the values as you go down the rows.

My guess is something with Repeat region -> relations but then I'm stuck

This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

[James62]

From my understanding of repeat regions I'd say that previous rows are not accountable to the current row.

Could you explain more of what you are trying to do?

[ErikClacey]

It's a shame if specific values in a repeat table cannot be accessed.

I have a pipe with lots of bends in it. Right now the table lists the bend angle from the previous bend. I would like to add them after each bend so that I see how the bend totals up after each bend. I can then see if we can handle it in our bending machine.

[Dale_Rosema]

Brian has had some interesting thread regarding summations, tables and repeat regions. You may want to search on Brian Table, Brian Row, ....

Here is a link to a couple of threads. Maybe you can glean something from them for what you are looking for:

http://communities.ptc.com/message/188670#188670

http://communities.ptc.com/message/210481#210481

There was one specific about summation and getting a total length. I haven't found that thread yet, but if I do I'll add that link.

This may be it:

http://communities.ptc.com/message/178572#178572

Thanks, Dale

[James62]

Ok, could you post an example of a table like that, and describe where should the bend angles come from?