 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Total Amount vs X amount | Login/Join |
| Platinum Member |
Is there a way to show on a single report the following: Total amount is Column 1 X amount is Column 2. Percent of X from Total amount is column 3. X, Y, and Z items would make up total amount. Is this possible? All data can be found in one table. Thanks, Joe WebFocus 7.7.02 WinXP | ||
|
| Guru |
Yes, its is possible Developer Studio 7.64 Win XP Output: mostly HTML, also Excel and PDF "Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor | |||
|
| Expert |
ROFL!!! I concur with Nubi that it is possible. Research multi verb requests such as - SUM field BY sort1 PRINT field BY sort1 T
| |||||||||
|
| Guru |
this is what i was getting at- this is WebFOCUS 101 type of stuff.. i think this is the only way to learn, its much better working this stuff out than just being told an answer because that way when you have to do this again in the future you'll remember how you do it rather than remembner that the answer is in the forum somewhere.... use: WF manuals WF help file WF search forum archives experimentation all should be available to you to support the training you had and is as much as anyone one else here has.... Developer Studio 7.64 Win XP Output: mostly HTML, also Excel and PDF "Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor | |||
|
| Virtuoso |
I support Nubi's anwer... although it seems to be not so client friendly.... Joe: please post a bit more info, make an example of the report that is less puzzling and try to work out something based on the CAR database. That will help everybody to understand better what you'r up to...
| |||||||
|
| Guru |
i agree Frank that somtimes you 'have to be mean to be nice'  im just trying to 'help people help themselves' and rolling out all the cliches while im at it...  Developer Studio 7.64 Win XP Output: mostly HTML, also Excel and PDF "Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor | |||
|
| Expert |
SET ASNAMES = ON APP PATH ibisamp TABLE FILE CAR SUM SALES AS TOTSALES BY COUNTRY SUM SALES COMPUTE SHARE/D4%=100*C2/C1; BY COUNTRY BY CAR END -* C1 IS COLUMN 1; C2 IS COLUMN 2; Cnotation doesn't count BY fields. i'm willing to give Joe a head start... Its Labor Day and i'm WORKING!!! 
| |||||
|
| Virtuoso |
It has alwyas seemed a bit odd to me - labor day and NOT working .... I mean, isn't that what labor stands for? GamP
| |||||||||
| ||||||||||
| Expert |
GamP, You have to remember that Americans spell it wrong anyway T | |||
|
| Guru |
TonyA, Just because we no longer want to look as if we are FRENCH with the way words are spelled, does not mean it is spelled wrong. WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit | |||
|
| Expert |
Robert, I was "fishing" as it was only tongue in cheek to see what I could catch. Look what I landed  T
| |||||||||
|
| Guru |
American Developer Studio 7.64 Win XP Output: mostly HTML, also Excel and PDF "Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor | |||
|
| Guru |
Developer Studio 7.64 Win XP Output: mostly HTML, also Excel and PDF "Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |