Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Regarding Currency subtotals and grand totals
 Login/Join
 
mahesh1982
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, 2010Report This Post
Francis Mariani
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, 2005Report This Post
mahesh1982
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, 2010Report 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
 
Report This Post
mahesh1982
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, 2010Report This Post
GamP
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 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
mahesh1982
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, 2010Report This Post
Prarie
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, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders