Recently I have been working on building a template file for my drafting work in Spotlight. I feel like I have stumbled into an issue with the limitations with the built in Worksheet functionality of Spotlight and possibly the base Fundamentals as well. Basically what I am trying to do is pull information from the databases into the worksheet, summarize and count by Symbol, Cable Length & Type, etc. I then would like to use the count function to get a total of that particular item so I can do some math with it to calculate the spare and total counts for my pull sheets.
What I have found is that the worksheets don't work this way when using the database row/sub-rows in 2022 SP2.1. For example, on my Hoist Pull Sheet worksheet, when I summarize the symbols listed in A2 and then do an =COUNT in D2 I get the proper count of the hoists in the drawing. In E2 I do the function =ROUNDUP((D2*0.2), 0) but it only calculates to 1, no matter if I have 1 or 15 as the count in a sub row of D2. in F2 I did a =SUM(D2, E2) and I somehow got it to say 11 + 1 equals 2.
What I am hoping to see in a future service pack update is for worksheets to recognize when a database row and it's sub-rows have been summarized by a column and to allow math to be done in columns following a summarized entry as if it is a spreadsheet. I know some may suggest that I export my worksheets to Excel, but I feel like that defeats the purpose of what I am trying to do with this template file and making my paperwork generation quick, easy and having a consistent look for my vendors and clients.