Turn on suggestions

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

Showing results for

- Navigation
- Tecnomatix
- Forums
- Blogs
- Knowledge Bases
- Groups

- Siemens PLM Community
- Tecnomatix
- Plant Simulation
- Formula in Tables including strings

Options

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

Formula in Tables including strings

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-01-2019 08:44 AM

Is it possible to use a formula to combine strings in a table to create a chart? I am trying to create a simple chart where people would just have to fill in the top bar and the rest automatically fills in but i seem to get the error: *Addressing by index is only possible for lists, arrays or for objects with capacity >1*

i tried by using ?[3,0]+".statWorkingPortion" or by putting a sum of strings combining two cells. Picture can be found below.

Thanks!

3 REPLIES 3

Re: Formula in Tables including strings

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-01-2019 09:21 AM

Re: Formula in Tables including strings

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-01-2019 02:54 AM - edited 05-01-2019 02:58 AM

It works in principle, but I would advise against it.

You would have to enter a *formula* (by clicking the "Formula" button in the ribbon bar) into the Input Channels table. The source code of the formula would be something like this:

@[1,0] + ".StatWorkingPortion"

Note that in a formula **?** refers to the object (in this case the Chart), and **@** refers to the table itself (in this case the Input Channels table).

_________________________________________________________________

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

Re: Formula in Tables including strings

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-02-2019 03:53 AM

Upon second reading, I would also advise against your approach using formulas.If you fill up the whole table with formulas, but some header cells are not filled in, you will get errors.

You already want the user to take some actions. Therefore I would recommend either a kind of wizard (there already is a built-in wizard in the chart) or a drag-and-drop control where you fill in the header and the references to the statistics.

Follow Siemens PLM Software

© 2019 Siemens Product Lifecycle Management Software Inc