Hi all,
i am trying to put a QML together in order to report for each part the sum of its uses in different parent parts. This would allow us to have a view of how much a given part is used across in our assemblies.
So I was indeed able to count all occurrences and combine them to only count different parent parts (latest iteration), but I am struggling with their revisions. As of now the report is counting all revisions that a part is used in, and this leads to inaccurate information...
So then I tried to use the kind of sub-select that can be used to find only the latest revision (BranchID), but this leads to only displaying the latest revision of all parts in our database as parent part. It seems I am not able to narrow the condition for the latest revision to the parts of same number.
Has anybody an idea how to get to the results to account only for the latest revision of the parent parts?
Attached you find the report, it was made on Windchil 10.1.
greetings
