[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

Title:FOCUS, from INFORMATION BUILDERS
Moderator:ZAYIUS::BROUILLETTE
Created:Thu Feb 19 1987
Last Modified:Mon May 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:615
Total number of notes:1779

122.0. "HELP ! HELP ! Reporting with COMPUTE" by CSG::SETTY () Tue Aug 30 1988 15:22

  
    
    HELP !    HELP !     HELP !
  
        We tried to generate a report using the following .FEX file.
    
  
    TABLE FILE CALC
    PRINT ASV NOPRINT LEV_FACTOR NOPRINT APP_FACTOR COPRINT
    COMPUTE
    ACTUAL=(QUANTITY*ASV*(LEV_FACTOR)*APP_FACTOR)); NOPRINT
    BY VCODE BY PRODUCT BY APPLICATION
    BY 'SYSTEM TYPE' NOPRINT
    BY QUARTER NOPRINT
    BY QUARTER NOPRINT
    ON TABLE COLUMN-TOTAL
    ON VCODE SUBFOOT
    "ACTUAL($M) FOR VENDOR <ST.ACTUAL"
    END
    -RUN
    -EXIT
  
 
    The EXPECTED report should look like:
  
        VENDOR1  PRODUCT   APP     ACTUAL (For vendor 1)
        VENDOR2  PRODUCT -------   ACTUAL (For vendor 2)
  
        Total Actual: -------
  
    BUT the report comes out with blanks in the ACTUAL column as if
    the values for SYSTEM TYPE were printed and the SUBFOOT works fine.
  
    Without the NOPRINT the ACTUAL for each SYSTEM TYPE will be 
    printed.
  
    We have had many many phone conversations with IBI, but still no
    progress. Any suggestions?
  
    Regards,
  
    Sathya Setty   DTN 291-0503
T.RTitleUserPersonal
Name		DateLines