Kevin K Posted August 1, 2021 Share Posted August 1, 2021 Pat Stanford, you awake? 🙂 Question for you.  Note the screenshot below. In the worksheet, I would like to be able to calculate JUST the total living space areas noted in the worksheet. This possible?  -Kev      Quote Link to comment
Art V Posted August 1, 2021 Share Posted August 1, 2021 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) Quote Link to comment
Pat Stanford Posted August 2, 2021 Share Posted August 2, 2021 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. Quote Link to comment
Kevin K Posted August 2, 2021 Author Share Posted August 2, 2021 Thanks, Pat & Art for your suggestions. I of course can facilitate this desire in other ways, but was hoping I could easily pluck the desired data from the database items. Quote Link to comment
Recommended Posts
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.