Focal Point
[CLOSED] Add an Average Column and Variance column.

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7677062276

August 20, 2014, 03:27 AM
raghuram
[CLOSED] Add an Average Column and Variance column.
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
August 21, 2014, 04:37 AM
Ram Prasad E
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


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/