Summing data in optional section

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex Fung - 23 Sep 2005 23:21 GMT

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

Reply to this Message

Andrew Watt [MVP - InfoPath] - 24 Sep 2005 10:46 GMT

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

>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
[quoted text clipped - 6 lines]
>
>Thanks

Reply to this Message