Summing data in optional section

[Alex Fung]

I have multiple optional sections that are collapsed by default. Each
optional section has a control for users to fill in a numeric value. I tried
to create a control that will generate a grand total on the numeric controls
in all the optional section, but the grand total value returns 'NaN'. It
appears the grand total formula (section 1 total + section 2 total) will only
work if all the optional section is expanded. Is there a work around that'll
allow me to show a numeric value in the grand total control when one or more
optional section is not enabled?

Thanks

 

[Andrew Watt [MVP - InfoPath]]

I think you might have to script this.

Using Expression boxes and XPath to get totals a default value of 0
in a text box in an optional section appears to be treated as NULL (I
think) or maybe the empty string and therefore gives NaN until the
optional section is created.

Andrew Watt
MVP - InfoPath