thedoccontroller
Board Regular
- Joined
- Dec 15, 2015
- Messages
- 82
So... Using XL2016, I have queried a table on Sheet1 and am loading the results of that query on Sheet2. In the queried table, I am showing the result of a simple formula with the table column formatted as a decimal (i.e. cell shows the result as 0.25). However, the query and the loaded results (also formatted as decimals) show "0.00". I have some screen shots below to try to demonstrate. Please let me know if and what other info you might need to help me out here.
<tbody>
</tbody>This is the Table on Sheet1. The RT column displays the result of =(([@Total]-INT([@Total]))*24).
"LSU" shows the result of =[@[R.T.]]-[@[Set-Up]].
My query results are shown on Sheet 2 and look like:
<tbody>
</tbody>
All the formula results show up as 0 regardless of the formatting I have tried.
Is there anything I can do?
FYI: The point of the query is to consolidate the data to be extracted via a macro and added to a report. there are dozens of these time studies created every week with varying table rows and steps in ColA. Since the table size varies, I want to avoid having to add rows to both tables, hence the query to copy the data.
Please Help!
Part Step | T1 | T2 | T3 | T4 | SET-UP | TOTAL | QT | RT | LSU | ORDER QTY | PER HR |
Step1 | 5:47P | 5:59P | 0.18 | 0:12 | 0 | 0.0230 | 0.02 | 50 | 250 | ||
Step2 | BLAH | BLAH | bLAH | BLAH | 0.12 | .025 | -0.02 | ||||
Step3... | 0.03 | 0.0333 | -0.24 |
<tbody>
</tbody>
"LSU" shows the result of =[@[R.T.]]-[@[Set-Up]].
My query results are shown on Sheet 2 and look like:
Part/Step | Q.T. | R.T. | LESS SU | PER HR |
C&S-C4 | 0 | 0.00 | 0.00 | 250 |
Cable&cord Assy | 0.12 | 0.00 | 0.00 | 200 |
Bench Term | 0.03 | 0.00 | 0.00 | 1500 |
Assembly | 0.33 | 0.00 | 0.00 | 214 |
<tbody>
</tbody>
All the formula results show up as 0 regardless of the formatting I have tried.
Is there anything I can do?
FYI: The point of the query is to consolidate the data to be extracted via a macro and added to a report. there are dozens of these time studies created every week with varying table rows and steps in ColA. Since the table size varies, I want to avoid having to add rows to both tables, hence the query to copy the data.
Please Help!