[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

501.0. "** Help With Average **" by RDGE44::SYMONDSK () Tue Mar 17 1992 09:01

    Dear Some one:
    
    I am having problems with trying to produce the following:
    
    i.e
    
    DUMMY     AVE.CUR_AMT      AVE.AGE     AVE.CO_SERV
    -----     -----------      -------     -----------
        2          25,700            3               5 
        3          25,700            7               4
    
    AVERAGE        12,850            5             4.5
    
    ------------------------------------------------------------------------
    
    THE FOLLOWING CODE IS WHAT I HAVE:
    
    TABLE FILE Z_H14
    SUM DUMMY 
        AVE.CUR_AMT
        AVE.AGE
        AVE.CO_SERV
    BY SH_LCL_LV
    ON SH_LCL_LV RECAP AVE_AMOUNT/D8.2=AVE.CUR_AMT;
    END
    
    AND IT PRODUCES THE FOLLOWING :
    
                AVE        AVE  AVE
    DUMMY       CUR_AMT    AGE  CO_SERV
    -----       -------    ---  -------
        1         9,200     20        4
        1         9,250     19        1
       12         9,979     30        4
        2         9,975     24        5
    
 ** AVE_AMO       38404
    
 Can any one Help
    Kevin.
T.RTitleUserPersonal
Name		DateLines
501.1Still struggling ???KAHALA::FOREMANNothings Impossible, you just run out of timeTue Mar 24 1992 10:095
    Did you ever work this one out.  I'm not too sure what you're trying
    to accomplish here, but you may need to do some COMPUTE statements
    or at least do add some BY fields and use the WITHIN clause.
    
    Sharon
501.2try something like thisUSMFG::BHYNESFri Mar 27 1992 13:0016
    As .1 says I.m not sure what you are trying to do, but you might try
    something along these lines..
    
    TABLE FILE Z_H14
    SUM DUMMY AVE.CUR_AMT AVE.AGE AVE.CO_SERV
    BY SH_LCL_LV
    BY DUMMY NOPRINT
    ON DUMMY RECOMPUTE AVE.CUR_AMT AVE.AGE AVE.CO_SERV AS 'AVG-AMOUNT'
    END
    
    
    
    
    
    bob