Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- Creo Parametric
- :
- Assembly Design
- :
- How to do total of table content?

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

08-08-2012
02:34 AM

08-08-2012
02:34 AM

How to do total of table content?

the lenght in table is driven by parameters..

i use relation in assembly to add all the lenght parameters

and is working fine but...

now, i need to add two new angles in this assembly and i want automated addition of length by the time i add them up in assembly.

is it possible? or any solution plz share

Labels:

8 REPLIES 8

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

08-08-2012
03:21 AM

08-08-2012
03:21 AM

Re: How to do total of table content?

Hi Dalbeer...

Are you looking for a simple **Summation** of the lengths in your table? If so, there's literally a** Summation** command for repeat regions that can handle this (provided those length values are real numbers and not strings).

If I'm misunderstanding your question, please let me know. If you need a picture or some quick step by step instructions, let me know.

Thanks!

-Brian

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

08-08-2012
04:19 AM

08-08-2012
04:19 AM

Re: How to do total of table content?

plz do share

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

08-08-2012
05:31 AM

08-08-2012
05:31 AM

Re: How to do total of table content?

Hi Dalbeer...

Not my usual quality but it's 5:30am and I haven't slept! I hope this gets the point across. Write back if this doesn't make sense.

I really, really hope that makes sense. The **Summation** tool is useful but rarely used because it has some idiosyncrasies that need to be heeded for the function to work. This should be what you're looking for. Good luck!

Thanks!

-Brian

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

08-08-2012
06:11 AM

08-08-2012
06:11 AM

Re: How to do total of table content?

Dear Brian,

thanx 4 ur fast prompt. but i think i hvnt explain clearly the problrm .. if u look at the PIC, the table shows 6 itmes from 2-7 where they hv qty and lenght mentioned now i want that the table should calculate sum of all the lenght of parts itself (qty.*length and then total sum). and when i add another part into the assm. it automaticaly genrate the sum in table.

Thanx

-Dalbeer

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

08-08-2012
08:13 AM

08-08-2012
08:13 AM

Re: How to do total of table content?

Put a cell to the right that is the multiplication of the two columns, then use Brian's method to sum up the up the multiplication column.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

08-08-2012
09:45 AM

08-08-2012
09:45 AM

Re: How to do total of table content?

Hi Dale/Dalbeer...

I went to bed thinking this same thing (as Dale's idea). Basically Dalbeer, you can use a table relation to multiply the quantity value by the length value. Something like:

x = qty * length

Creo/ProE will use this relation to automatically calculate the "x" value for each item in the BOM. Once you have that, you can use the technique I posted the first time to get your summation. As a side note, it may be possible to create the relation and * not* show the "x" value in it's own column before summing. I haven't tried this though. It may be necessary to add "x" to it's own column before it can be summed. You'll have to give it a try to find out for certain.

If you have trouble with this, just let me know and I'll do another couple of slides to demonstrate.

Thanks!

-Brian

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

08-08-2012
11:05 AM

08-08-2012
11:05 AM

Re: How to do total of table content?

worked fine...

but i dont want the size column...

thanx brian and dale

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-22-2014
10:43 AM

04-22-2014
10:43 AM

Re: How to do total of table content?

All

please find that post about weight roll out

Weight rollup in Windchill 10.1 M040

think that need have to be handle in a dynamic cognos report or WPA if you are using full Windchill solution

(but same problem for lightweight Intralink solution)

Due to the dynamic nature of a multilevel structure ...

regards