Im new to webfocus so this may be very basic .
I am displaying a Goal percentage in the table but its value is shown as 94.2000000.

How do I modify this in the Define table?
I need to display only 94.2
This is what im using.

TABLE FILE DIVISION_WEEK
PRINT ST_GOAL_PCT
WHERE RECORDLIMIT EQ 500
ON TABLE PCHOLD FORMAT HTML
END
-EXIT

This message has been edited. Last edited by: <Kathryn Henning>,

You can try

TABLE FILE DIVISION_WEEK
PRINT ST_GOAL_PCT/D10.1
WHERE RECORDLIMIT EQ 500
ON TABLE PCHOLD FORMAT HTML
END

If you want to display your datas as its like in DB, you need to convert the format to ALPHA using FPRINT function.

TABLE FILE CAR
SUM DC DC/D8.2
COMPUTE ALPHA_DC/A10=FPRINT(DC,'D7',ALPHA_DC); 
BY COUNTRY
END 

quote:

/D10.1

Yes it worked Thanks Francis I tried the D10.1.

Thanks guys.