Can InfoAssit do this?

January 04, 2013, 01:52 PM

I'm at a loss and don't want to bark up this tree if it's Not Doable. Probably more doable in 8.x? It is doable in "The Code", perhaps even in the GUI.

But, can it be done in InfoAssit?

                                                        REG                 DIST                  STORE
                                                        % of                % of                   % of 
Division Region District Store   TOT DIV     TOT REG      DIV   TOT DIS      REG      TOT STORE    DIST  
       1     11      206  1445  100,000.00   25,000.00  25.00%  10,000.00  40.00%      1,000.00   10.00%

January 05, 2013, 05:02 AM

FrankDutch

Yes you can, but I am sure we can better help you if you post more info about source and database structure.

January 08, 2013, 05:20 PM

Doug

I'm sorry Frank, I was too into this to be more intuitive... How about something like this:

Div	Reg	Dis	Store	Amount
1	1	106	445	1000
1	11	206	1445	1000
1	21	306	2445	1000
1	31	406	3445	1000
1	41	506	4445	1000
1	51	606	5445	1000
1	61	706	6445	1000
1	71	806	7445	1000
1	81	906	8445	1000
1	91	1006	9445	1000
. . .		1106	10445	1000
1	111	1206	11445	1000
1	121	1306	12445	1000
1	131	1406	13445	1000
1	141	1506	14445	1000
. . .				
2	161	1706	2445	1000
. . .				
2	261	1906	3445	1000
. . . e t c

Where the total division eq 100000, region eq 25000, total district eq 10000 and this store eq 1000. Shall I do a McGuyver or something?

January 08, 2013, 05:29 PM

Doug

How about this?

SET PAGE = NOLEAD
SET BYDISPLAY = ON
TABLE FILE GGSALES
SUM DOLLARS/D20 AS 'DOLLARS,PRODUCT,LEVEL'
DOLLARS/D20 WITHIN REGION   AS 'DOLLARS,WITHIN,REGION'
DOLLARS/D20 WITHIN CATEGORY AS 'DOLLARS,WITHIN,CATEGORY'
DOLLARS/D20 WITHIN PRODUCT  AS 'DOLLARS,WITHIN,PRODUCT'
COMPUTE PCT_DOL_REG/D12%  = (TOT.DOLLARS / DOLLARS) * 100 ; AS 'PCT,DOL,REG'
COMPUTE TOT_DOL_CAT/D12.2 = IF CATEGORY EQ LAST CATEGORY THEN TOT_DOL_CAT + DOLLARS ELSE DOLLARS ; AS 'TOT,DOL,CAT'
COMPUTE PCT_DOL_CAT/D12%  = (TOT_DOL_CAT / DOLLARS) * 100 ; AS 'PCT,DOL,CAT'
BY REGION SUBHEAD
""
BY CATEGORY SUBTOTAL AS 'Total'
BY PRODUCT
WHERE REGION CONTAINS 'east'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
GRID=OFF, BORDER=LIGHT,BORDER-STYLE=DOTTED, FONT=ARIAL, SIZE=10,$
TYPE=TITLE, STYLE=BOLD, BACKCOLOR=RGB(244 244 244),$
TYPE=SUBTOTAL, STYLE=BOLD, BACKCOLOR=RGB(222 222 222),$
TYPE=GRANDTOTAL, STYLE=BOLD, BACKCOLOR=RGB(200 200 200),$
ENDSTYLE
END

January 08, 2013, 05:31 PM

Francis Mariani

Ah, but, can it be done in InfoAssist ?

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

January 09, 2013, 01:25 PM

TMoorthy

Good question. I too would like to know how to do this in InfoAssist. WITHIN does not seem to be valid operator in InfoAssist 7.3

T

January 10, 2013, 06:17 PM

Doug

And this is the foundational question:

quote:
... can it be done in InfoAssist?

The post of Tue Jan 08 2013 17:29 was an example of what is desired...

quote:
... WITHIN does not seem to be valid ...

Unfortunate but True, as far as I know. So, what creativity can be done in InfoAssist to accomplish these results?

	*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