Search
Search

# How to display a subtotal on a report footer ?

Hello

I have a report that has

Group header #1 a, on this (group header # 1a) it's grouping by a customer no and on this group i have a formula which has some text(it's a letter) and I display the letter then below the letter I have

Group Header #2 a. where I display one line that has an address information then

Group Header #2 b. this has the header information things like, invoice_no,invoice_date,amount, currency. then

Group Header #3. this has the currency(no show) then

Group Header #4. this display the currency code either, USD or CHF or EUR then below this is

the Details : this has the detail of what is on Group Header #2 b, the, invoice_no,invoice_date,amount,currency then I have

Group footer #4

Group footer #3: this is the currency where I have a total by currency

Group footer #2

Group footer #1 : this is the customer no

Now the question, how can I display a summary of all subtotals at the button of the report, most of the time I will have 2 types of currency on the report per customer.

I want display  a summary for both , for example

Total in USD is :

Total in EUR is :

Total in CHF is :

Thank you

##### Abhilash Kumarreplied

Hi Alpa,

1) Create a formula with this code and place this on GH:

If {table.currency} = 'CHF'

Then

Shared Numbervar chf :=

Sum ({table.AMOUNT_DUE}, {table.CURRENCY})

Else if {table.currency} = 'SFX'

Then

Shared Numbervar sfx :=Sum ({table.AMOUNT_DUE}, {table.CURRENCY})

2) Create two separate formulas one for each currency:

Place them on the report footer to display the value:

Shared numbervar chf;

You can also add the fee charge value to this variable.

-Abhilash

0 View this answer in context