Nathan,

Try using regular (non-optional) sections along with conditional
formatting for hiding them: this way, each of your sections will be in
the XML, so InfoPath won't give you NaN, instead using 0 for their value
if they are undefined.

Good luck,
Alex @ Microsoft

-----Original Message-----
From: NathanDW [mailto:NathanDW@discussions.microsoft.com]
Posted At: Saturday, May 14, 2005 11:09 PM
Posted To: microsoft.public.infopath
Conversation: How to add values found on optional sections
Subject: How to add values found on optional sections

I have an invoice form which allows me to select the types of billing I
need
for a particular invoice; example: I have four "optional sections":
Items
billed by hour, items billed by quote, itemized expences, and misc. I
can
select 1, none, all, etc. of these and enter several lines of values
useing
repeating tables. Each optional section has a total. At the bottom of my

invoice form there is a text box which value is a function that adds the

totals from each optional section. If all the sections are not active or

created then the value returned is "NAN". I am assuming that unless you
"insert" a section the objects associated with that section are not
created
so when the function tries to add the totals it cannot find them and the

function fails. What I think I need is a functions that tests to see if
the
desired Section/section total exsists and then adds it to the total if
it
does. I have used VBA for word and excel but can't figure it out for
infoPath.

Please Help,
Nathan Winder