Samuel Derenboim Posted September 27, 2021 Share Posted September 27, 2021 The last two columns are calculating incorrectly Column Z = P / O Column AA = T / S Table cell calculations for P = =IF((('!CDA-EnergyTabular'.'Solid/Glass')='solid'), '!CDA-EnergyTabular'.'U_prop'*AREA, '') O = =IF((('!CDA-EnergyTabular'.'Solid/Glass')='solid'), '!CDA-EnergyTabular'.'U_req'*AREA, '') T = ='!CDA-EnergyTabular'.'U_prop'*AREA S = ='!CDA-EnergyTabular'.'U_req'*AREA Is there something going on here that I'm not aware of? Quote Link to comment
0 michaelk Posted September 27, 2021 Share Posted September 27, 2021 Wow. That's weird. Can you post the worksheet with enough objects to give some data? Quote Link to comment
0 Pat Stanford Posted October 2, 2021 Share Posted October 2, 2021 Just an anomaly in worksheets. On SUMmarized subrows, a formula is run on each hidden row and then the results of the formula are added together. There is no good work around. 😞 Quote Link to comment
Question
Samuel Derenboim
The last two columns are calculating incorrectly
Column Z = P / O
Column AA = T / S
Table cell calculations for
P = =IF((('!CDA-EnergyTabular'.'Solid/Glass')='solid'), '!CDA-EnergyTabular'.'U_prop'*AREA, '')
O = =IF((('!CDA-EnergyTabular'.'Solid/Glass')='solid'), '!CDA-EnergyTabular'.'U_req'*AREA, '')
T = ='!CDA-EnergyTabular'.'U_prop'*AREA
S = ='!CDA-EnergyTabular'.'U_req'*AREA
Is there something going on here that I'm not aware of?
Link to comment
2 answers to this question
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.