calculate %-value of amount of separate doc_type out of total amount

[Former Member]

hi all.

In report I need columns:

1. DEBITOR

2. DOC_TYPE

3. AMOUNT (of DOC_TYPE)

4. % (of doc_type amount out of total amount of Debitor)

for example

DEBITOR DOC_TYPE AMOUNT PERC_OF

******************************************************

00001 AB 100 50 %

00001 AC 50 25%

00001 AD 50 25%

00002 AB 80 80%

00002 AC 20 20%

how can I do this by Report Designer?

[Former Member · Accepted solution]

Add Sub-totals to Debtor and use the %CT formula in the percent column.

Brian