Post by LMWI'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/