InfoPath Dev

I guess I really have three questions.

1. Is there a limit to how long a formula can be in a function box?

2. Can you add the results from 2 or more functions boxes together in another function box?

3. When using division (/) in a formula, I keep getting the error "Expected value type: end-of-string Actual value: )"

I've played around with the parentheses, but cannot figure it out. Below is my extremely large formula if you'd like to see what I'm working with. I apologize. Now you see the reason for my first two questions. Thanks!

sum(dfs:dataFields/d:tblFHeader/d:tblSec1/@fld11S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld12S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld13S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld14S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld15S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld16S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld17S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld18S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld19S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld110S)+ (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld21S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld22S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld23S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld24S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld25S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld26S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld27S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld28S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld29S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld210S)+(dfs:dataFields/d:tblFHeader/d:tblSec3/@fld31S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld32S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld33S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld34S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld35S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld36S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld37S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld38S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld39S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld41S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld42S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld43S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld44S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld45S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld46S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld47S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld48S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld49S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld410S)+ (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld51S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld52S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld53S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld54S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld55S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld56S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld57S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld58S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld59S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld510S)+(dfs:dataFields/d:tblFHeader/d:tblSec5/@fld511S)+ (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld61S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld62S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld63S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld64S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld65S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld66S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld67S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld68S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld69S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld610S)+ (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld71S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld72S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld73S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld74S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld75S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld76S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld77S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld78S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld79S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld81S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld82S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld83S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld84S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld85S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld86S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld91S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld92S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld93S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld94S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld95S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld96S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld97S) div sum((dfs:dataFields/d:tblFHeader/d:tblSec1/@fld11S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld12S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld13S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld14S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld15S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld16S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld17S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld18S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld19S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld110S)+ (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld21S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld22S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld23S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld24S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld25S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld26S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld27S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld28S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld29S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld210S)+(dfs:dataFields/d:tblFHeader/d:tblSec3/@fld31S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld32S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld33S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld34S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld35S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld36S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld37S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld38S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld39S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld41S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld42S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld43S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld44S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld45S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld46S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld47S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld48S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld49S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld410S)+ (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld51S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld52S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld53S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld54S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld55S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld56S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld57S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld58S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld59S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld510S)+(dfs:dataFields/d:tblFHeader/d:tblSec5/@fld511S)+ (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld61S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld62U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld63S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld64S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld65S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld66S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld67S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld68S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld69S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld610S)+ (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld71S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld72S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld73S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld74S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld75S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld76S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld77S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld78S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld79S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld81S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld82S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld83S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld84S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld85S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld86S) + sum(dfs:dataFields/d:tblFHeader/d:tblSec9/@fld91S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld92S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld93S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld94S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld95S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld96S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld97S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld11U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld12U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld13U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld14U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld15U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld16U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld17U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld18U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld19U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld110U)+ (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld21U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld22U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld23U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld24U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld25U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld26U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld27U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld28U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld29U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld210U)+(dfs:dataFields/d:tblFHeader/d:tblSec3/@fld31U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld32U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld33U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld34U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld35U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld36U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld37U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld38U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld39U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld41U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld42U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld43U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld44U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld45U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld46U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld47U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld48U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld49U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld410U)+ (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld51U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld52U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld53U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld54U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld55U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld56U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld57U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld58U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld59U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld510U)+(dfs:dataFields/d:tblFHeader/d:tblSec5/@fld511U)+ (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld61U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld62U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld63U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld64U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld65U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld66U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld67U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld68U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld69U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld610U)+ sdfs:dataFields/d:tblFHeader/d:tblSec7/@fld71U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld72U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld73U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld74U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld75U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld76U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld77U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld78U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld79U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld81U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld82U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld83U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld84U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld85U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld86U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld91U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld92U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld93U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld94U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld95U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld96U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld97U))

It looks like you are missing an end-parenthesis right before the div.

Wouldn't that mean I'd need one at the beginning too, right after sum? I tried it both ways. It's still giving me an error pertaining to an end parenthesis. I don't know what else to check.

On second glance, it looks like those sum functions aren't really doing anything.  You should remove both sums text and enclose the first half of the formula in a pair of parentheses.  It looks like you are getting that error because in this line:

sdfs:dataFields/d:tblFHeader/d:tblSec7/@fld71U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld72U) +

You have an s instead of an open parenthesis.

Thanks Jimmy!

That was it.

Tammy

Now there are no errors in the formula, but it seems to just be adding everything together instead of adding the first set and dividing by the second set. I tried enclosing the second set in parentheses but that gave me an error.

Any clues? I've re-pasted the formula.

Thanks! 

sum(dfs:dataFields/d:tblFHeader/d:tblSec1/@fld11S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld12S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld13S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld14S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld15S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld16S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld17S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld18S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld19S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld110S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld21S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld22S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld23S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld24S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld25S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld26S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld27S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld28S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld29S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld210S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld31S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld32S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld33S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld34S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld35S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld36S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld37S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld38S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld39S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld41S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld42S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld43S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld44S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld45S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld46S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld47S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld48S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld49S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld410S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld51S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld52S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld53S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld54S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld55S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld56S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld57S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld58S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld59S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld510S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld511S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld61S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld62S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld63S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld64S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld65S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld66S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld67S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld68S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld69S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld610S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld71S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld72S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld73S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld74S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld75S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld76S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld77S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld78S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld79S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld81S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld82S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld83S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld84S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld85S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld86S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld91S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld92S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld93S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld94S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld95S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld96S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld97S) div sum(dfs:dataFields/d:tblFHeader/d:tblSec1/@fld11S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld12S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld13S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld14S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld15S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld16S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld17S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld18S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld19S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld110S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld21S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld22S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld23S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld24S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld25S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld26S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld27S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld28S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld29S) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld210S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld31S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld32S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld33S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld34S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld35S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld36S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld37S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld38S) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld39S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld41S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld42S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld43S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld44S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld45S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld46S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld47S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld48S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld49S) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld410S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld51S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld52S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld53S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld54S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld55S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld56S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld57S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld58S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld59S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld510S) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld511S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld61S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld62U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld63S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld64S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld65S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld66S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld67S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld68S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld69S) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld610S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld71S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld72S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld73S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld74S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld75S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld76S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld77S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld78S) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld79S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld81S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld82S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld83S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld84S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld85S) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld86S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld91S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld92S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld93S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld94S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld95S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld96S) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld97S) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld11U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld12U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld13U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld14U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld15U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld16U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld17U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld18U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld19U) + (dfs:dataFields/d:tblFHeader/d:tblSec1/@fld110U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld21U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld22U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld23U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld24U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld25U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld26U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld27U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld28U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld29U) + (dfs:dataFields/d:tblFHeader/d:tblSec2/@fld210U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld31U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld32U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld33U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld34U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld35U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld36U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld37U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld38U) + (dfs:dataFields/d:tblFHeader/d:tblSec3/@fld39U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld41U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld42U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld43U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld44U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld45U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld46U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld47U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld48U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld49U) + (dfs:dataFields/d:tblFHeader/d:tblSec4/@fld410U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld51U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld52U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld53U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld54U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld55U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld56U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld57U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld58U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld59U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld510U) + (dfs:dataFields/d:tblFHeader/d:tblSec5/@fld511U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld61U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld62U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld63U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld64U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld65U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld66U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld67U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld68U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld69U) + (dfs:dataFields/d:tblFHeader/d:tblSec6/@fld610U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld71U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld72U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld73U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld74U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld75U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld76U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld77U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld78U) + (dfs:dataFields/d:tblFHeader/d:tblSec7/@fld79U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld81U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld82U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld83U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld84U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld85U) + (dfs:dataFields/d:tblFHeader/d:tblSec8/@fld86U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld91U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld92U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld93U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld94U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld95U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld96U) + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld97U)

Yes, as I said in my previous post, remove both sums as they are currently doing nothing, and enclose both halves of the formula (before and after div) with another set of parentheses, like:

((dfs:dataFields/d:tblFHeader/d:tblSec1/@fld11S) + la dee da + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld97S)) div
((dfs:dataFields/d:tblFHeader/d:tblSec1/@fld11S) + yippe de doo + (dfs:dataFields/d:tblFHeader/d:tblSec9/@fld97U))

Thanks! I will try this and let you know what happens.

Tammy