KOOD wrote:
TYPE USER ID GROUND STORY 1ST STORY TOTAL
WINDOW C001 5 5 10
WINDOW C002 3 2 5
WINDOW C003 3 2 5
WINDOW C004 4 4 8
WINDOW C005 2 3 5
After study the help file of AC ,I find it's impossible to general window list directly from AC like above .I do know how to get window list by story but still need to do some work in EXCEL to achieve my desired window list .
Anybody can help?
So, you want the quantity subtotal by story and grand total on one line.
No, AFAIK, it is not possible to generate this kind of report within AC by using just IS or a list scheme. (You could do it - only as a theoretical point, but not a practical one - by using some strange GDL scripting and a temporary external file.)
AFAIK, the best way to produce this kind of thing is to export the quantity info from the list scheme (component or otherwise) or the I.S. and to process it in Excel or Access/Filemaker. You could write a script there to avoid the manual work.
Karl
One of the forum moderators
AC 28 USA and earlier • macOS Sequoia 15.2, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB
