General

Re: Help with a SUM function in repeating table footer

Reema Daga — Mon, 26 Oct 2015 16:19:22 GMT

Glad to help! Have a great week!

-Reema

Re: Help with a SUM function in repeating table footer

jhudson1977 — Mon, 26 Oct 2015 16:12:03 GMT

Thanks again! Another one of those simple mistakes. Now that I see it, I'm doing the DOH!

Re: Help with a SUM function in repeating table footer

Reema Daga — Mon, 26 Oct 2015 15:40:05 GMT

Hi Jason,

You are using the wrong field in the formula. It should be LineTotal instead of Total.

Thanks,

Reema

Reema Daga
Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Re: Help with a SUM function in repeating table footer

jhudson1977 — Mon, 26 Oct 2015 13:55:47 GMT

Sure. Would you like to PM me your email address?

Re: Help with a SUM function in repeating table footer

Reema Daga — Mon, 26 Oct 2015 13:46:09 GMT

Can you please email me your form?

Thanks,

Reema

Reema Daga
Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Re: Help with a SUM function in repeating table footer

jhudson1977 — Sun, 25 Oct 2015 15:05:40 GMT

It is checked.

Re: Help with a SUM function in repeating table footer

Reema Daga — Sun, 25 Oct 2015 13:25:06 GMT

Hi there,

Thank you for your post on infopathdev. Can you please under textbox properties check if the "Refresh value when formula is recalculated" check box is checked?

Hope this helps!

Kind Regards,

Reema

Reema Daga
Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Help with a SUM function in repeating table footer

jhudson1977 — Sat, 24 Oct 2015 16:14:45 GMT

I'm trying to create a form in which I have a repeating table for the purposes of creating new line items in a capital expense request form. I have a QTY column and PRICE column that I simply multiply together to form the line item total. Then, in the footer, I have a form TOTAL field that is supposed to total all of the line item totals. The line item totals are working great. The footer total however simply stays at $0.00 regardless of the number of lines. I have tried the field as fx and now text box with a fx inside. The formula is simple -- sum(../my:group3/my:Line_Item/my:Total). No rules are running on the form yet. Fairly simple...I thought. Any suggestions?