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 ' '
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.
ThanksThis message has been edited. Last edited by: <Kathryn Henning>,
Excel, PDF, HTML
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
|Powered by Social Strata|