I have multiple shapes that I have copy & pasted. (screenshot 1) I have added a field called FY24 which has numbers from a data import. (screenshot 2) I used the Page>Data to create a field called “FY24” and then used the formula `SUM(CHILDREN.”FY24”). (screenshot 3) No summing is occurring I will attach a few screen shots as well. What am I missing? Thank you. Screenshot 1Screenshot 2Screenshot 3 Like Quote

Summing of Containers

I have multiple shapes that I have copy & pasted. (screenshot 1)
I have added a field called FY24 which has numbers from a data import. (screenshot 2)
I used the Page>Data to create a field called “FY24” and then used the formula
`SUM(CHILDREN.”FY24”). (screenshot 3)
No summing is occurring

I will attach a few screen shots as well. What am I missing? Thank you.

Like
Quote

Page 1 / 1

I figured it out. Because the containers I am trying to access are actually groups. I have to reference them with the “DESCENDANTS” function instead of the “CHILDREN” function.

Hi @HEC-User, thanks for posting in the Lucid Community! I’m glad to hear you were able to answer your question! One helpful resource I would recommend for you or other users working with formulas is our Use formulas in Lucidchart article from the Lucid Help Center. It contains helpful information to help you get started with formulas and has additional resources to reference. Please let me know if you have any further questions!

Reply

Create an account in the community

Login with SSO

Log in to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded