Controls

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

Ted Fitch — Thu, 15 Jul 2010 23:05:06 GMT

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

Add/total repeating table field values based on month

andyoye — Thu, 27 May 2010 02:58:18 GMT

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