Add/total repeating table field values based on month - InfoPath Dev
in

InfoPath Dev

Add/total repeating table field values based on month

Last post 07-15-2010 04:05 PM by Ted Fitch. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 05-26-2010 07:58 PM

    Add/total repeating table field values based on month

    Reply Contact

    I have a repeating table with 3 columns: Task(text), Date(Date field), Hrs(text). Users add their task, date the worked on and # of Hrs the spent.

    I want to sum "Hrs" but based on months like: Total number of hours for May = ?

                                                                        Total number of hours for June = ?

     

     Thanks

     

  • 07-15-2010 04:05 PM In reply to

    Re: Add/total repeating table field values based on month

    Mark as Answer
    Reply Contact

    Hi,

    You could use “FormatDate” in our qRules product to return just the month to an additional field, and then base a sum expression on that with a filtered XPath…

    You could also use a formula to get just the month part of the date  But qRules is easier to do this with.

     

    Ted

     
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.