How to add values found on optional sections

[NathanDW]

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

 

[NathanDW]

" conditional formatting for hiding them " ?

 

[NathanDW]

Thank you,
That did the trick, I used check boxes and conditional formating to control
section display. Now to make it absolutely perfect is there a setting to have
the check boxes not display when the form is printed. It is not vital but
will clean up the printed form a bit.

Thank you very much for your help,
Nathan Winder

 

[NathanDW]

I just figured out the answer to my previous question "hidding the check
boxes" I just create a custome print view that doesnt have the check boxes