Jump to content

Calculating portions of database items within a Worksheet


Recommended Posts

Maybe if you would add a record to the areas that declares the type of space (e.g. living space, storage space, etc.) you could create an IF function that selects the ones where that record says it is a living space and then calculate the total of those areas (or any other area type depending on selection criteria)

Link to comment

I agree with Art V the best way (most robust and least likely to break later) would be to have a record/field (either one of the fields that are part of the space or a custom record/field attached to the space) that would indicate which spaces are Living areas.

 

You should then be able to use a formula like (not test and done from memory):  =Area('KKRecord'.'LiveArea'='True') to get the summed area.

 

There is no way to pick just selected subrows out of a database.  VW thinks of subrows as dynamic. Someone could change the sort order, or add or delete an item, so that the next time the worksheet recalculates, the data could be in different subrows. So rather than try to figure out which new subrow matches with with old one, they just protect you from yourself (and themself from you) by not allowing subrows to be directly accessed.

 

Ask again if you need more help.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...