Possible for master to display sum of child numeric values?

L

LMW

I'm exploring whether Visio could be used in the following fashion. I would
like for a parent shape to display the sum of shape data fields within child
shapes? Is this doable?
 
P

Paul Herber

I'm exploring whether Visio could be used in the following fashion. I would
like for a parent shape to display the sum of shape data fields within child
shapes? Is this doable?

Yes, very easy. If you know the name of the two child shapes and the field names, then in
the parent shape enter a formula into a suitable cell, user-defined cells or shape data
cells will do nicely. Something like =Shape1!cellname+Shape2!cellname. You can then
display this cell.

For example: if you have two shapes Sheet1 and Sheet2 then you can create a formula
=Sheet1!User.q + Sheet2!Prop.r
 
D

David J Parker [MVP Visio]

It most certainly can.
You can use a formula like:
=SUM(Sheet.6!Prop.Cost, Sheet.8!Prop.Cost, Sheet.10!Prop.Cost)
where sheet.n is the NameID of the child shapes.
I'm not sure what you mean by child shapes - are they sub-shapes in a group,
or connected shapes, or within a container.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top