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     [CLOSED] Add an Average Column and Variance column.
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Add an Average Column and Variance column.
 Login/Join
 
Gold member
posted
Am new to Webfocus and need some assistance in the below scenario.


Date 14-Jan 14-Feb 14-Mar
Product Sub Product
Retail Walmart 13 15 0
Target 11 12 13
BestBuy 10 10 0
Bank Citibank1 2 0
HSBC 3 0 3
US bank 0 2 2



I need to add two new column in this report:

Average (Avg all months displayed)

Variance of Current month to Avg (Current month - Avg)/Avg



Code which am using now:

SUM COUNT/P13 AS ' '
BY PRODUCT
BY SUB_PRODUCT
ACROSS DATE
COMPUTE AVG/P13 = C1+C2+C3;

Here the problem is am getting the row totals but need the averages excluding zero.

So please suggest how to proceed.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.6.7
Windows
Excel, PDF, HTML
 
Posts: 56 | Registered: February 04, 2010Reply With QuoteReport This Post
Master
posted Hide Post
Below code will give you an idea.
APP PATH IBISAMP
TABLE FILE CAR
SUM
COMPUTE D_C/D20.2=DEALER_COST; NOPRINT
COMPUTE CNT_CAR/I11=CNT.CAR; NOPRINT
BY COUNTRY 
SUM
DEALER_COST AS ''
BY COUNTRY
ACROSS CAR
COMPUTE AVERAGE/D20.2=D_C/CNT_CAR;
END

Thanks,
Ram
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Add an Average Column and Variance column.

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