I'm creating a 6th column which is a computed column(TOTAL) that will bring sum of COL1 COL2 COL3 for each row.
Problem is the above logic should occur for CLAIMS,NGCNT,SALES which is sum (COL1 COL2 COL3). That said, for SALES PER CLAIM row the logic is different, formula for this is (sales/ claims). I should get the report like below.
If you see in the above output the "SALES PER CLAIM" row value for the column "TOTAL" has value which is came out from the formula (sales/Claims).
How can we achieve the sum of the row values for each metric and at the same time specifically for "SALES PER CLAIM" row a different value based on the formula(sales/Claims) in a single computed column
Thanks!This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.10 Windows Output: Excel,PDF
October 09, 2010, 04:23 PM
GamP
TABLE FILE xxxx
PRINT COL1 COL2 COL3
COMPUTE TOTCL/I6 = IF METRIC EQ 'CLAIMS' THEN COL1+COL2+COL3 ELSE TOTCL; NOPRINT
COMPUTE TOTSL/I6 = IF METRIC EQ 'SALES' THEN COL1+COL2+COL3 ELSE TOTSL; NOPRINT
COMPUTE COL4/I6 = IF METRIC EQ 'SALES PER CLAIM' THEN TOTCL/TOTSL ELSE COL1+COL2+COL3;
BY STORE
BY METRIC
END
This might be what you're looking for ...
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
October 10, 2010, 03:08 PM
Dan Satchell
I suggest one change to GamP's post above:
COMPUTE TOTCL/I6 = IF METRIC EQ 'CLAIMS' THEN COL1+COL2+COL3 ELSE LAST TOTCL; NOPRINT COMPUTE TOTSL/I6 = IF METRIC EQ 'SALES' THEN COL1+COL2+COL3 ELSE LAST TOTSL; NOPRINT COMPUTE COL4/I6 = IF METRIC EQ 'SALES PER CLAIM' THEN TOTCL/TOTSL ELSE COL1+COL2+COL3;