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     [SOLVED] Percentage of sub-total rather than percetage of grand total
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Percentage of sub-total rather than percetage of grand total
 Login/Join
 
Member
posted
Hello all.

I am able to get the revenue percentage for each given entry using PCT as follows:

COMPUTE MTDRevenue_PoT/D7.4% = PCT.MTDRevenue;

This works beautifully but is based on the grand total of the report. If, however, the report was subtotaling by month I would want to show this same percentage of revenue for each month. As such, is there a similar helpful "PCT" command to get this, such as SUBPCT or something to that effect?

Thanks all!

Edit: I found the following example that appears like it would work, but I receive a parsing error on "WITHIN":

COMPUTE MTDRevenue_PoG/D7.4% = PCT.MTDRevenue WITHIN RevenueMonth; AS 'Monthly Percent'

RevenueMonth is the primary "BY".

This message has been edited. Last edited by: Jeff-TTC,


WebFocus Server 8.2.01M
WebFocus App Studio 8.2.01M
Windows Server 2012 R2 Standard
All Outputs
 
Posts: 6 | Registered: November 20, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try this:
  
TABLE FILE CAR
SUM PCT.RCOST WITHIN COUNTRY NOPRINT
COMPUTE JEFF/D6.2%=C1;
BY COUNTRY SUBTOTAL
BY CAR
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1976 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Member
posted Hide Post
That worked!

Thanks much!


WebFocus Server 8.2.01M
WebFocus App Studio 8.2.01M
Windows Server 2012 R2 Standard
All Outputs
 
Posts: 6 | Registered: November 20, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Jeff,
That it worked is a fact.
The question is: do you understand?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1976 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Percentage of sub-total rather than percetage of grand total

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