Sub-totals can be used in any Worksheet within JEstimator.

Sub-totals are like control characters and are implemented by entering the characters '*', '#', '!', and '%' in the UNIT column of any Worksheet other than the Section List whereby they are entered in the 'CO' column.

Each column in a worksheet that has the 'Show Sub-Totals' attribute turned on, has three sub-total registers. These are referenced within the worksheet by you using the '*', '#', and '!' in the UNIT or CO column.
When the program encounters one of these flags, it displays/prints the current value of the appropriate sub-total register for each column.

Think of these flags as:

'*' Sub-Total
'#' Total
'!' Grand Total

it is important to note that there is a hierarchy involved as such, as you can zero (reset) the appropriate flag's register for the Sub-Totals and Totals by including a second character (the '*') with the flag.

e.g. if you enter the flag '**', the sub-total register will be zeroed; if you enter the flag '#*', then both the Total and Sub-Total registers will be zeroed.
NOTE: You cannot zero the Grand Total flag.

The '%' flag is quite different. It simply adds the percentage of the Grand Total at that point to the Worksheet into the Value Column. The percentage used is derived from the value in the QTY column of the worksheet.

The process detailed above is dynamic - every time a change is made to the worksheet, these flags are obeyed and the results calculated instantly.