TABLE FILE 0401_S
SUM
Membership
MEM_CHG NOPRINT
TREND AS 'Trend'
PER_MEM AS '% of Mbsp'
FEMALE_PCT AS '% Female'
MALE_PCT AS '% Male'
AVG_AGE AS 'Avg Age'
PAID_PMPM/P20.2:C AS 'PMPM'
BY EMPLOYERDESC_ATTRIBUTE AS 'PPG'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SUBTOTAL SUM. Membership AVE. PER_MEM AVE. FEMALE_PCT AVE. MALE_PCT AVE. AVG_AGE SUM. PAID_PMPM
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
INCLUDE=IBFS:/WFC/Repository/WF_Style/ConiferBase_FR.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
TYPE=HEADING, JUSTIFY=CENTER, FONT='ARIAL', SIZE=11, COLOR=RGB(75 75 75), $
TYPE=DATA ,COLUMN=N4 ,BORDER-RIGHT=ON ,BORDER-RIGHT-COLOR=RGB(0 0 0), $
DEFMACRO=Condition_1, MACTYPE=RULE, WHEN=N3 GT 0, $
DEFMACRO=Condition_2, MACTYPE=RULE, WHEN=N3 LT 0, $
DEFMACRO=Condition_3, MACTYPE=RULE, WHEN=N3 EQ 0, $
TYPE=DATA, COLUMN=N4, MACRO=Condition_1, IMAGE=IBFS:/WFC/Repository/Images/kpi_indicators/RedUpArrow.gif, SIZE=(.15 .15), $
TYPE=DATA, COLUMN=N4, MACRO=Condition_2, IMAGE=IBFS:/WFC/Repository/Images/kpi_indicators/GreenArrowDown.gif, SIZE=(.15 .15), $
TYPE=DATA, COLUMN=N4, MACRO=Condition_3, IMAGE=IBFS:/WFC/Repository/Images/kpi_indicators/YellowDash.gif, SIZE=(.18 .12), $
ENDSTYLE

This message has been edited. Last edited by: FP Mod Chuck,

Hello Sherrihe,
Can could be more specific,

If you want the image in as a column then you can put it in define/compute field.

DEFINE FILE CAR
IMAGE/A100=IF COL_1 EQ 1 THEN 'IMAGE_1.JPG' ELSE IF COL_1 EQ 2 THEN 'IMAGE_2.JPG' ELSE 'IMAGE_3.JPG';
END

I don't really understand, you need images in footing?

I need an image on the ON TABLE SUBTOTAL line between SUM. Membership and AVE. PER_MEM that show s an up arrow, down arrow or even symbol based on the MEM_CHG value that is not displayed since it is a number.

This Post may help...

That shows you how to put it on a detail line. I need it on a total line

How about saving the values and images that you want using DEFINE FILE and displaying that as ON TABLE SUBFOOT instead of ON FIELD SUBTOTAL.