Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Regarding Currency subtotals and grand totals
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Regarding Currency subtotals and grand totals
 Login/Join
 
Member
posted
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,


webfocus 7.6
Windows
Excel, HTML, PDF
 
Posts: 6 | Registered: September 28, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Have you read the WebFOCUS manual?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Reply is really appreciated please. i want to do grant total on this.


webfocus 7.6
Windows
Excel, HTML, PDF
 
Posts: 6 | Registered: September 28, 2010Reply With QuoteReport This Post
<JG>
posted
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
 
Reply With QuoteReport This Post
Member
posted Hide Post
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


webfocus 7.6
Windows
Excel, HTML, PDF
 
Posts: 6 | Registered: September 28, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Member
posted Hide Post
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.


webfocus 7.6
Windows
Excel, HTML, PDF
 
Posts: 6 | Registered: September 28, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
As JG said

quote]ON CURRENCY SUBTOTAL



A GRAND TOTAL is of Absolutely no value with mixed currencies[/quote]
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Regarding Currency subtotals and grand totals

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.