December 14, 2004, 10:08 AM
<KPBHATT>is there a way to hold data in recap calculation
we are currently trying to generate a report with a graph alongwith the table data and %calculations here is the codebase:
**********************************************************************
TABLE FILE ACCT_DESC
-* ON TABLE HOLD AS TEST
SUM
'CNT.DIR_ITEM_MSTR.DIR_ITEM_I' AS 'COUNT,DIR_ITEM_MSTR.DIR_ITEM_I'
ACROSS
'ACCT_DESC.Yr_Wk' AS ' '
FOR
DIR_ITEM_MSTR.Itext
'No of Item with Errors' AS 'No of Item with Errors' LABEL R1 OVER
'Items with out Error' AS 'Items with out Error' LABEL R2 NOPRINT OVER
RECAP R3/I5=R1+R2;
AS 'No of Launched Sku's' OVER
RECAP R4/I5=R1/R3*100;
AS 'Launch Error%'
**********************************************************************
At the time of holding this output to a file, the fields with RECAP calculation are not getting stored.
Is there any way to hold 'Launch Error%' which is in RECAP calculation?