General

Re: computation results, storage, etc.

Greg Collins — Fri, 12 Nov 2004 18:46:22 GMT

If you are using InfoPath SP1 you can use a formula as a default value for a field. This formula can do the kinds of operations you mentioned. The value can update automatically when the other fields change.

Greg Collins [InfoPath MVP]

Re: computation results, storage, etc.

jonbrave — Fri, 12 Nov 2004 12:55:02 GMT

Not sure, but I did an MSDN search for "sum infopath".

Article "Summary View Calculations in the Calculations Developer Sample Form" seems all about this.

Also, article "Using a Custom Script Library for Common Tasks" descibes the functions in Common.js, which has "sum" function: "Returns the sum of the nodes that match the specified XPath expression. You can use this function to create running totals."

?

computation results, storage, etc.

octavio — Fri, 12 Nov 2004 10:33:23 GMT

hi,

is there a way for me to multiply (or add, sub, div for that matter) the values entered into 2 different fields and store its product on another data source, then sum all these products to compute for a grand total to be displayed.

to illustrate, i have a field for QUANTITY and UNIT COST, multiply the entered values then display to a textbox/expression box TOTAL. these fields reside on a repeating table so there can be several TOTALs, then i want to sum these totals and display it in a textbox or an expression box (what's better?) as GRAND TOTAL.

please advice. any help would be greatly appreciated. tnx