Re: Calculated Field in a Secondary Data Connection

adamrharding — Fri, 16 Nov 2007 12:04:55 GMT

I think if I understand you correctly then yes, you can.

Put a field in the repeating table linked back to your main source. Set its default value to your sum, but filter both elements by having a field for the row number of the row on the table.

I hope this helps

Cheers

Calculated Field in a Secondary Data Connection

blackhawk — Tue, 13 Nov 2007 16:59:04 GMT

Is there a way, without coding, to put a new field into a repeating table that is driven by a secondary data source, where this field performs a calculation on two other fields within each row of the repeating table?

For example, I have one column for 2006 and another column for 2007, and what I want to calculate is the variance between the columns.

I can create a field in the main data source contained within a repeating group and place it in the table, but I only get the results of the first record. If this is the right methodology for doing this? If so, what I can't figure out is: Should I be filtering off the secondary data source or the main data source, and what context does Current() operate in; the repeating table or the main data source?

Here is the actual calculation:

xdXDocument:GetDOM("History")/dfs:myFields/dfs:dataFields/tns:StringResponse/tns:StringResult/default/QueryResults/DataRow/Col8
- xdXDocument:GetDOM("History")/dfs:myFields/dfs:dataFields/tns:StringResponse/tns:StringResult/default/QueryResults/DataRow/Col7

Thanks for the help.

Data Connections

Re: Calculated Field in a Secondary Data Connection

Calculated Field in a Secondary Data Connection