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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better π
Register LoginAdvertisement