This function is intended for copying summary fields from other locations in the hierarchy. CopyField always copies the source value from other locations, even if the row is hidden.
It is possible to copy a value from:
a sub-row to an upper row
an upper row to a sub-row
a row to another row
a row to a header
a row to a footer
a header to a row
a footer to a row
a Sum field
For a header, page headers, page footers or a footer, the function copies the value of the given value field to itself.
If this function is used in row rules, it only copies the values from the row itself and not from other rows at the same level in the hierarchy or rows lower in the hierarchy.
A value field containing the CopyField function cannot be sorted.
In this example, there is an ASSEMBLY row with two rows on a lower level. One of the lower rows is a PART row and the other one is a SUMMARY row.
The SUMMARY row has a value field Summary_field containing the following formula:
The calculated weight is shown on the ASSEMBLY row in a value field with the following formula (and you can hide the SUMMARY row):
See also