B
blackhawk
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.
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.