Hi Folks,

I have a .mas file that has a structure similar to the follow example:

 FILENAME=FTE_LOAD, SUFFIX=FOC     , $
  SEGMENT=SEG01, SEGTYPE=S1, $
    FIELDNAME=AS_DATE, ALIAS=E01, USAGE=YYM, FIELDTYPE=I,
      MISSING=ON,
      TITLE='AS_DATE', $
  SEGMENT=SEG02, SEGTYPE=S1, PARENT=SEG01, $
    FIELDNAME=DELIVS_KEY, ALIAS=E02, USAGE=A6, FIELDTYPE=I,
      MISSING=ON, $
    FIELDNAME=DELIVS_NAME, ALIAS=E03, USAGE=A50,
      MISSING=ON, $
  SEGMENT=SEG03, SEGTYPE=S1, PARENT=SEG02, $
    FIELDNAME=DBDS_KEY, ALIAS=E04, USAGE=A6, FIELDTYPE=I,
      MISSING=ON, $
    FIELDNAME=DBDS_NAME, ALIAS=E05, USAGE=A100,
      MISSING=ON,
      TITLE='DBDS_NAME', $
    FIELDNAME=DBDS_NAME_TAR, ALIAS=E06, USAGE=I3,
      MISSING=ON,
      TITLE='DBDS_NAME_TAR', $
    FIELDNAME=DBDS_IARU, ALIAS=E07, USAGE=A3,
      MISSING=ON, $
  SEGMENT=SEG04, SEGTYPE=S1, PARENT=SEG03, $
    FIELDNAME=DBDR_KEY, ALIAS=E08, USAGE=A7, FIELDTYPE=I,
      MISSING=ON, $
    FIELDNAME=SERIAL_NOA, ALIAS=E09, USAGE=A3,
      MISSING=ON, $
    FIELDNAME=SERIAL1, ALIAS=E10, USAGE=A16,
      MISSING=ON, $
    FIELDNAME=DESCRIPTION, ALIAS=E11, USAGE=A200,
      MISSING=ON, $
    FIELDNAME=FREENOTES, ALIAS=E12, USAGE=A3000,
      MISSING=ON,
      TITLE='FREENOTES', $ 
  SEGMENT=SEG05, SEGTYPE=S1, PARENT=SEG04, $
    FIELDNAME=IM_KEY, ALIAS=E13, USAGE=A7, FIELDTYPE=I,
      MISSING=ON, $
    FIELDNAME=LFSTEP, ALIAS=E14, USAGE=A5,
      MISSING=ON, $
    FIELDNAME=GATE, ALIAS=E15, USAGE=A6,
      MISSING=ON, $
    FIELDNAME=GATEDESC, ALIAS=E16, USAGE=A50,
      MISSING=ON,
      TITLE='GATEDESC', $
    FIELDNAME=DESCBDS, ALIAS=E17, USAGE=A12,
      MISSING=ON, $
    FIELDNAME=DESCBDS_LONG, ALIAS=E18, USAGE=A51,
      MISSING=ON, $
    FIELDNAME=MATVAL_TAR, ALIAS=E19, USAGE=D6.1,
      MISSING=ON, $
    FIELDNAME=MATVAL, ALIAS=E20, USAGE=I4,
      MISSING=ON, $ 

Load .fex to build this mas:

 TABLE FILE INTIAL_LOAD_2
SUM 
AS_DATE    	
BY AS_DATE 		NOPRINT
 
SUM
DELIVS_KEY
DELIVS_NAME 
BY AS_DATE  	NOPRINT
BY DELIVS_KEY 	NOPRINT
 
SUM
DBDS_KEY
DBDS_NAME
DBDS_NAME_TAR
DBDS_IARU
BY AS_DATE 		NOPRINT
BY DELIVS_KEY 	NOPRINT
BY DBDS_KEY 	NOPRINT
 
SUM 
DBDR_KEY
SERIAL_NOA
SERIAL1 
DESCRIPTION
FREENOTES
BY AS_DATE 		NOPRINT
BY DELIVS_KEY	NOPRINT
BY DBDS_KEY 	NOPRINT
BY DBDR_KEY 	NOPRINT
 
SUM
IM_KEY
LFSTEP
GATE
GATEDESC
DESCBDS
DESCBDS_LONG
MATVAL_TAR
MATVAL
BY AS_DATE		NOPRINT
BY DELIVS_KEY 	NOPRINT
BY DBDS_KEY 	NOPRINT
BY DBDR_KEY 	NOPRINT
BY IM_KEY 		NOPRINT
ON TABLE HOLD AS FTE_LOAD FORMAT FOCUS INDEX AS_DATE DELIVS_KEY DBDS_KEY DBDR_KEY IM_KEY
END 

My issue is that when i sum these segments the integer values in DBDS_NAME_TAR are summed. I have only been using FOCUS for a few months now, is there an obvious problem i am misisng when it comes to building these mas files? I have tried to PRINT the values however this is throwing me some errors.

Would appreciate any guidance on the topic.

Many Thanks

- Jon

This message has been edited. Last edited by: Jon FB,

I have figured this out, i have been storing the integers incorrectly, i was repeating the values so it was being summed several times.

Hi Jon,

Look at using a prefix operator such as MAX. MIN. FST. LST. (maximum, minimum, first, last respectively)

To use them just prefix the field to which you need it applied - MAX.fieldname

T