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>,

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