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
- :
- Windchill Systems/Software Engineering (Integrity)
- :
- Integrity Discussions
- :
- Integrity - create field that is a computed sum

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

01-31-2017
11:38 AM

01-31-2017
11:38 AM

Integrity - create field that is a computed sum

Hello -

In Integrity 10.9, I'm trying to create a new field for my documents that is a computed sum of all "Verified By Trace Count" entries in a document.

The field "Verified By Trace Count" related to each requirement is calculated by:

isEmpty(RelCount("Verified By"),0);

So, at the document level, I was hoping the sum of all these values would simply be:

sum("Verified By Trace Count");

but that always gave me the error:

"An error occurred parsing the computation expression "sum("Verfied By Trace Count");": MKS124539: sum: Function is an aggregate function, but a non-aggregate computation is being evaluated."

I tried using the aggregate function, but couldn't quite get the syntax right.

Any help would be appreciated.

Is there a document that gives examples on how to use all these computational functions and operators?

Thanks!

John

Labels:

1 REPLY 1

Highlighted
##

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

05-06-2017
06:26 AM

05-06-2017
06:26 AM

Re: Integrity - create field that is a computed sum

Hi John,

the answer is: please use a different function like this:

isempty(aggregateByTree("Contains", References, sum(isempty("All Content Count",0))),0)

This function will walk along the document content and will sum detailed values.

Hope this helps

Volker