If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Possible for master to display sum of child numeric values?
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? |
#2
|
|||
|
|||
Possible for master to display sum of child numeric values?
On Fri, 23 Apr 2010 15:29:01 -0700, LMW wrote:
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/ |
#3
|
|||
|
|||
Possible for master to display sum of child numeric values?
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. "LMW" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|