Hi,

I am having a requirement that i need to do subtotal and grandtotal based on currency as well as customer name.

Say for example:

Table A has 10 customers, each of them has currencies 'EURO','USD', i want to display the subtotal of customer according to currencywise.Can any one help me on this by sending sample code pls.

Regards,
Mahesh

This message has been edited. Last edited by: Kerry,

Have you read the WebFOCUS manual?

Reply is really appreciated please. i want to do grant total on this.

Francis your'e getting as bad as me.

SORT BY CUSTOMER
SORT BY CURENCY NOPRINT
ON CURENCY SUBTOTAL

Research BY, NOPRINT and SUBTOTAL

A GRAND TOTAL is of Absolutely no value with mixed currencies

Thanks, I have tried this

I have appended country and currency in a single variable and used Recompute on that variable and sort that by the variable. I am able to get subtotal. But grand total not coming. I have used ON TABLE COLUMN-TOTAL for computing grand total. Can you pls quickly help on this.Many thanks again

Between the red < / > code tags, post the code you currently have. That way we may be able to better serve you than just guessing what it is you need.

Thanks.my example is

SUM Amount
by customer
by currency
on currency recompute
--UPTO THIS IS WORKING FINE AND CALCULATING SUBTOTAL.

ON TABLE COLUMN-TOTAL AS 'Grand Total':Amount

Can u pls tell me how to calculate grandtotal based on currencies.

As JG said

quote]ON CURRENCY SUBTOTAL



A GRAND TOTAL is of Absolutely no value with mixed currencies[/quote]