Discussion:
Possible for master to display sum of child numeric values?
(too old to reply)
LMW
2010-04-23 22:29:01 UTC
Permalink
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?
Paul Herber
2010-04-26 12:14:22 UTC
Permalink
Post by 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?
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
--
Regards, Paul Herber, Sandrila Ltd.
Electronics for Visio http://www.sandrila.co.uk/visio-electronics/
Electrical for Visio http://www.sandrila.co.uk/visio-electrical/
Electronics Packages for Visio http://www.sandrila.co.uk/visio-electronics-packages/
David J Parker [MVP Visio]
2010-04-26 12:46:48 UTC
Permalink
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.
Post by 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?
Continue reading on narkive:
Loading...