Default Values can either be static::
Or calculable:
This means that this field, LINE TOTAL, will have a default value of
<INVOICE TOTAL> - <LINE TOTAL>
<INVOICE TOTAL> in this scenario is a Header Field. The value is equal to the value in header field with name <INVOICE TOTAL>.
<LINE TOTAL> in this scenario is a Detail Field. The value is equal to the sum of values in the detail fields <LINE TOTAL>.
We start with a Header Field <INVOICE TOTAL>, with value $100.00
There are no rows present so the default row defaults to a LINE TOTAL value of $100.00
Editing this value to 20.00, will cause the newly created default row to have a default value of
<INVOICE TOTAL> minus the sum of the <LINE TOTAL> in the rows, 100 – 20, or 80. Adding another row of 20, will create a default row of 100 – 20 – 20, or 60:
