Percent Subtotal in Info Assist

You could use the PCT prefix and WITHIN syntax. I don't use InfoAssit I am not sure if the GUI gives you these options.

TABLE FILE CAR
SUM
   DEALER_COST
   PCT.DEALER_COST/D20.2% WITHIN COUNTRY AS 'PERCENT'
    
BY COUNTRY
BY MODEL
ON COUNTRY SUBTOTAL AS 'TOTAL'
ON TABLE NOTOTAL
END

WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files

Posts: 320 | Location: Memphis, TN | Registered: February 12, 2008

Ignored post by Mighty Max posted

Member

posted

Hey Max - Thank you for your response. The WITHIN command doesn't seem to work in InfoAssist. I get the following error when I try to use in a compute command:

(FOC224) SYNTAX ERROR: WITHIN BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

Here's my formula:

PCT.Total WITHIN Division

Formatted as D12.2%

WebFOCUS 7.6
Windows, All Outputs

Posts: 5 | Registered: December 13, 2012

Ignored post by IA_Newbie posted

Tony A

Expert

posted

How is your count field being calculated?

I have just created an IA report using GGSALES, added a define - TOT_COUNT/D12 = 1, and then computed a field as PCENT/D12.2% = PCT.TOT_COUNT. This seemed to work OK for me.

This should equate to -

DEFINE FILE GGSALES
  TOT_COUNT/D12 = 1;
END
TABLE FILE GGSALES
  SUM TOT_COUNT
      COMPUTE PCENT/D12.2% = PCT.TOT_COUNT;
   BY REGION
   BY ST
ON TABLE RECOMPUTE
END

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Member

posted

Hey Tony - maybe I'm missing something, but that doesn't give me a percent of Subtotal. The percent calculation still evaluates to percent of Column total.

My data does not contain aggregation measures, so I often have to count a text field to produce summaries. e.g. CNT.CustomerNumber where CustomerNumber is alphanumeric.

To be a little bit more clear, here's what my output looks like now:

Category Result Count Percent
Division_1 Failed 47 .91
Success 115 2.23
*TOTAL Division_1 162 3.14
---------------------------------------
Division_2 Failed 927 17.97
Success 4069 78.89
*TOTAL Division_2 4996 96.86
----------------------------------------
TOTAL 5158 100.00

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

WebFOCUS 7.6
Windows, All Outputs

Posts: 5 | Registered: December 13, 2012

Ignored post by IA_Newbie posted

Member

posted

Oops! That doesn't look clear at all!

Sorry, I wish I could upload an image to show you what I'm seeing.

WebFOCUS 7.6
Windows, All Outputs

Posts: 5 | Registered: December 13, 2012

Ignored post by IA_Newbie posted

Tony A

Expert

posted

If you put example output then place it in a code tag pairing (the </> in the reply dialog).

If you have this output then I guess what you want is the percentages to be calculated within Category? As Max suggested, the WITHIN would be the best method, but I don't know whether you can achieve that in IA. If I get a chance tomorrow, I'll see what I can achieve.

Category          Result  Count  Percent  Wanted
Division_1        Failed     47      .91   29.01
                  Success   115     2.23   70.99
*TOTAL Division_1           162     3.14  100.00
------------------------------------------------
Division_2        Failed    927    17.97   18.55
                  Success  4069    78.89   81.45
*TOTAL Division_2          4996    96.86  100.00
------------------------------------------------
TOTAL                      5158   100.00  100.00

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

tlbrydie2

Platinum Member

posted

Hello,
I'm not sure if you have gotten your answer for this issue. But the IA product, beging purely GUI. After you have gragged your fields to the "Query" section of the tool..r-click on the field you want to "Sub-tot" on, select "Break" in the context menu and select "on:...simulary the fields that you want to be represented in a "%" format, r-click and choose "Edit Format" and select the "%' box....and that should give what you want.

Hope this helps

Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

Posts: 133 | Registered: December 29, 2006

Ignored post by tlbrydie2 posted

Member

posted

Thanks for the suggestion tlbrydie2. My question was more around the percent of subtotal calculation itself. If you look at Tony's last post, I'm looking for a way to calculate the "Wanted" column vs. "Percent", which the tool does by default.

WebFOCUS 7.6
Windows, All Outputs

Posts: 5 | Registered: December 13, 2012

Ignored post by IA_Newbie posted