Hi Mary Lou,

Yeah there is no out of the box solution, but you could probably do this with javascript.  One way it could work is to put a hidden field in your table, called 'Count' in the following example.  In that you could put =COUNTIF(Table.Qty, "> 0")  choosing your table name instead of table of course.  This will only put a number in there if the qty is not null or 0.  Then create a number field outside of the table which can also be hidden, in the case below it is just called 'Number'.  In this field give it the class 'qtyChecker' and under the advanced tab calculation box =MAX(Table.Count).  Now all you have to do is reference that in the javascript to look for a value greater than zero to expand the section.  You could use an IF statement and say if that number field is greater than zero then run the following statement:

$('#q14  .collapsible').trigger('click');

Just substitute your field number in place of the q14.