Get previous data in repeat region

Forum|Forum|12 years ago
September 16, 2013
1 reply
1870 views

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.

General

J

James62

1-Visitor

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?

E

ErikClacey

Author

14-Alexandrite

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.