Focal Point
is there a way to hold data in recap calculation

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

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?