FBernardo Posted September 20, 2022 Share Posted September 20, 2022 Hi all, How do you make a SUM being calculated from User field information either on window or door ? so far I've only managed to make the sum being calculated from entries and not the value inserted in the User field. Quote Link to comment
Pat Stanford Posted September 20, 2022 Share Posted September 20, 2022 The User Fields are stored as strings, so by default the numbers are not able to be summed. A formula of =Value(UserField1) should get you a number that can be summed, but there is not error checking that what is in the cell is a valid number. If you have 35mm in the field (including the unit) that will not be properly converted to a number. =Value('Window'.'UserFld1') For Doors and Windows the field are named as above. For one of the other common plugins (Spaces maybe??) the name is different. 1 Quote Link to comment
FBernardo Posted September 20, 2022 Author Share Posted September 20, 2022 Thanks @Pat StanfordI will give it a try! Quote Link to comment
FBernardo Posted September 21, 2022 Author Share Posted September 21, 2022 Hi @Pat Stanford, I've been trying to figure out how to use the formula you gave me, but not getting there. Let me try to explain, as I think I might have lacked a bit in details. I have a Schedule that is collecting information from all windows and doors and I need to add trickle vent for a ventilation calculation, so I say in Window A, B and C it needs 2 trickle vents of 5000 and so on, then I need to add all of the values from the windows to reach a total number, something like excel where you do a SUM of a column, but since I'm using the Userfield for this it doesn't read it as a number so it only gives me the number of Entries. So in this image the red column is the one that I need to add all the values, in the Blue rectangle to give me the total. Hope this makes sense? So far what I was using was the Centreline as this can be read as a value number and it actually works in the Sum, but I needed from Userfield as it's better than using the centreline! Quote Link to comment
Pat Stanford Posted September 21, 2022 Share Posted September 21, 2022 Can you send me the file so I can look at exactly what the different between the Row 4 and Row 5 databases? 1 Quote Link to comment
FBernardo Posted September 21, 2022 Author Share Posted September 21, 2022 10 minutes ago, Pat Stanford said: Can you send me the file so I can look at exactly what the different between the Row 4 and Row 5 databases? The database is the Row 4 is Window based and the Row 5 is Door based but sure i can try and send it when i'm at the job as my internet at home is terrible to upload files! Quote Link to comment
Pat Stanford Posted September 21, 2022 Share Posted September 21, 2022 Also, are you calculating the Equivalent Area? Or do you just want to enter the value manually for each window? Quote Link to comment
FBernardo Posted September 21, 2022 Author Share Posted September 21, 2022 59 minutes ago, Pat Stanford said: Also, are you calculating the Equivalent Area? Or do you just want to enter the value manually for each window? This is a manually entered value as it might differ from window to window or door to door... although in the screenshot attached earlier they are all equal by chance... Quote Link to comment
Alice_H Posted October 5, 2023 Share Posted October 5, 2023 Hello, is there an answer to this? I am trying to put together an area schedule that reports the volumes and areas of a set of spaces, and then totals them at the bottom so I get the total area and total volume. Inputting '=C2') or whatever just gives me the number of spaces being reported, not a sum of the values in that column Quote Link to comment
Pat Stanford Posted October 5, 2023 Share Posted October 5, 2023 We need more information about your use case to be able to help. Are you listing your Spaces in a Database row/subrows? If so, then you should just be able to add an additional column to the database to report the area (and spaces have multiple different Net/Gross areas, so you want to choose the correct one for your use and file setup). That should automatically total to the database header row. If the Area formula is in column D and the database is in Row 2 then =D2 should get you the total area of all the spaces in the database. If this is not your issue, please clarify what you are doing and trying to do. 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.