Counting sub-components in a DC
-
Hi -
Is there a function I can use to count sub-components in a DC?
I wish there were something like
=COUNTIF(Component!Element1)
Where Component is the top-level DC, and Element1 is a subcomponent that is repeated many times within the dynamic component.
-
Are you using the COPIES feature to create the copies?
If so, the countof a particular sub-component would be
=ComponentName!COPIES+1
-
@unknownuser said:
Are you using the COPIES feature to create the copies?
Sometimes. I'd prefer to use a direct count of the component, if possible.
When I do use the COPIES function, the component I want to count is embedded a few levels in. So I might have:
First Level: Main DC
Second Level: Component to copy
Third Level: Component to count (say 10 copies of this component for every Second Level component)I suppose I could use the COPIES function on the second level, and multiply by the copies of the Third Level component.
Advertisement