Xpath Expression in IP 2003- Optional Repeating tables "Dean" <deanl144[ at ]hotmail.com.nospam> 13.07.2006 13:14:37 I have a Repeating Section that contains 5 repeating tables, 2 of which are optional. I am trying to create an expression that can correctly add together fields from the footers of each table, but it only seems to work when all of the tables have data. When I do not put data into the optional tables then my grand total formula just gives me 1#QNAN. How can I create a formula that correctly handles these optional fields? TIA Dean

RE: Xpath Expression in IP 2003- Optional Repeating tables S.Y.M. Wong-A-Ton 14.07.2006 20:08:01 How does your formula currently work? Are you using rules with conditions? Just trying to understand the setup of your form... --- S.Y.M. Wong-A-Ton "Dean" wrote: [Quoted Text] > I have a Repeating Section that contains 5 repeating tables, 2 of which are > optional. I am trying to create an expression that can correctly add > together fields from the footers of each table, but it only seems to work > when all of the tables have data. When I do not put data into the optional > tables then my grand total formula just gives me 1#QNAN. How can I create a > formula that correctly handles these optional fields? > TIA > Dean > > >