The table below uses the RepeatBlockWhile task to create multiple rows and has a Word field to calculate the total of the one column. A running total (highlighted) is kept of the rows and then used as the default value for the Word field.

%[Total = 0; bContinue = True]

Description	Amount
%[RepeatBlockWhile(bContinue)] %[Query('Enter a Description', '')]	%[Amount =Query('Enter the Amount', '');FormatNum(Amount, 2)]%[Total = Total+Amount]%[bContinue = MsgBox('Adding rows', 'Add another value?')]
TOTAL	%['{\rtf1{\field{\*\fldinst {\b  =SUM(ABOVE) \\# "# ##0.00" }}{\fldrslt {\b   ' & FormatNum(Total,2) & '}}}}']

 

When you fill the table, the following occurs:

1. The first FillPoint sets the Total to "0" and the RepeatBlockWhile condition to "true":

%[Total = 0; bContinue = True]

2. The first Query box prompts you to enter a description:

3. The second Query box prompts you to enter an amount:

The amount is formatted with 2 decimal places:

50.00

4. The Amount then gets added to the Total:

0+50.00=50.00

5. You are then prompted to continue adding rows or not:

The result of this message box is the condition that the RepeatBlockWhile task is based on. If you click OK, the block will be repeated and you can add another description and amount. When you have finished adding items, click Cancel.

6. The final Total is filled in to the Word field and the result is displayed in the last row of the table. The table will then, for example, look similar to the following:

Description	Amount
Paper	50.00
Envelopes	30.00
Pens	15.00
TOTAL	95.00