Repeating Section - Format Sum Operation - InfoPath Dev
in

InfoPath Dev

Repeating Section - Format Sum Operation

Last post 06-21-2012 10:26 AM by xtremeIX. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 06-20-2012 02:48 PM

    Repeating Section - Format Sum Operation

    I have a repeating section with a field called "startTime" containing values in "hh:mm" format and I want the total of all the "hh" to display in another box outside of the repeating section.  I know if the "starTime" is a whole number you can say sum(startTime) and it adds all the numbers but, in the format I have for the field I tried sum(substring-before(startTime,":"))  and it doesn't work.  Any ideas?
  • 06-20-2012 09:22 PM In reply to

    Re: Repeating Section - Format Sum Operation

    I believe this should work:

    sum(eval(startTime, "substring-before(., ':')"))

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 06-21-2012 10:26 AM In reply to

    Re: Repeating Section - Format Sum Operation

    Worked perfectly; thank you!
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.