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] subtotal issue

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] subtotal issue
 Login/Join
 
Enigma006
Master
posted
Hai all

I am new to WebFOCUS. I am working on how to get data displayed like this. Can some one help me please?

Column1 Column2 Column3
data1 data2 data3

Column4 data4
Column5 data5
Column6 data6

This pattern should repeat for each record.
I am trying to use over but getting correct only partially..

And I need subtotals of column4, 5 and 6 by column2..I am getting wring values here..?!!

Please let me know of any questions.

Thanks

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


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
John_Edwards
Virtuoso
posted Hide Post
Take a look at FML -- Financial Modeling Language. It allows you to put anything you want wherever you want. A bit more work involved, but you'll get what you're looking for.

Also, consider putting all of it in the heading section or subheading section of the report and using "spot markers" to place the text (both column names and the data results) in any configuration you like. Look up "Spot Marker" in your help file and it will take you to a couple of pretty solid places to get started.

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
FrankDutch
Virtuoso
posted Hide Post
are the column4 and 5 and 6 multi values?
or only single values
if it is single you can put it in the header or footer or in the subfoot
the same with the totals




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
John_Edwards
Virtuoso
posted Hide Post
They could be in the body of the report.

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Enigma006
Master
posted Hide Post
Thanks for your replies. bcz of changes we had 2 reports.
Is there anyway to have subtotals on unique values of that columns??

Example output:

  

V1   V2  V3  V4   SUM1  SUM2 SUM3
A    B   C   G    10    20   30
A    B   E   F    10    20   30
ST                20    40   60

Subtotal of 3 sum fields on V1 gives 20 40 60 as V3 has different values. but it should give only unique values for each V2..!!
TABLE FILE T1
SUM
SUM1
SUM2
SUM3
BY V1
BY V2
BY V3
END

But I need output to look as above but sub total should show 10 20 30 only.?!
V1   V2  V3  V4   SUM1  SUM2 SUM3
A    B   C   G    10    20   30
A    B   E   F    10    20   30
ST                10    20   30

tried using RECAP but dint get it.
any suggestions?

Thanks


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
GinnyJakes
Expert
posted Hide Post
Try BY V2 SUB-TOTAL. That will give you a subtotal for V1 and V2.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report 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] subtotal issue

Copyright © 1996-2020 Information Builders