Search the Community
Showing results for tags 'worksheet function'.
-
- 7 replies
-
- hardware
- worksheet function
-
(and 2 more)
Tagged with:
-
Performing math on Spreadsheet and Database cells in a worksheet
Bill Treen posted a question in Troubleshooting
I have a worksheet for calculating roof height. Roof height is based on the weighted average of the individual roof areas relative to a geodetic height. In this worksheet, I have a database cell that picks up polygons that are linked to a record. The next column lists the areas of those polygons. I now have a nice list of the polygons, their names and their areas. In the next column I want to perform a division function where the individual areas are divided by the total area. Since the total area shows up in the column header. I can link a spreadsheet cell to this column header and the total area shows up in the spreadsheet cell. ie. same value HOWEVER, When I then try to divide the spreadsheet cell area by the database header value (to get the weighted average) the spreadsheet cell changes it value to zero and the operation fails. Is there a way to get information from a database cell and perform a math function on it without ruining the value of that cell?