Hello
I am currently trying to run a calculation in a chart that is on a single page but using many layers. Basically what I want to do is sum the value of all the shapes on the visible layers. What I have done at this point is assign values to all of the shapes in each layer (not all but all the relevant ones) then at the page level I retrieve all of the values using =CHILDREN."Value" and getting an array.
The array looks correct however it is returning the values of the shapes that are currently in layers that are hidden. Is there a way to return only the visible shape values??
Perhaps with conditional formatting or using certain IF statements with an identifier?
Please help!! Thanks :)
Michael
