cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Get previous data in repeat region

Highlighted
Contributor

Get previous data in repeat region

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

4 REPLIES 4
Highlighted

Re: Get previous data in repeat region

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?

Highlighted

Re: Get previous data in repeat region

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.

Highlighted

Re: Get previous data in repeat region

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

Highlighted

Re: Get previous data in repeat region

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

Announcements