AutoSum(Above) in Word
The "AUTOSUM(ABOVE)" merge field is used as a substitute for a "{=SUM(ABOVE)}" field in the following situations.
In performing merges that include detail regions, you may wish to include the total of a numeric column. This can be done using the {{AUTOSUM(ABOVE)}} merge field, which is ideal in the following situations:
- The cells contain international currency values
- The cells contain blank cells
- The cells contain negative values formatted with parentheses
This is particularly useful with currency values that display a multi-letter currency symbol, e.g., Danish Kroner. "50,0 kr." Before AUTOSUM, the native SUM(ABOVE) would find the total, but not display the currency symbol. AUTOSUM finds the SUM and retains the currency symbol and proper thousand and decimal delimiters. Note the number of columns in the row with the AUTOSUM field must match the number of columns on the rows above it.
The line items above this field entry must be formatted with the "\# Currency", "\# Currency0" or "\# Number" merge field formatting code. You may not use any merged cells on the row that contains the "AUTOSUM(ABOVE)" field. Also, AUTOSUM results are static and cannot be updated after the output document has been created.
