Hi,

I have a table stored in oracle which has the value in fraction for one column. When I try to sum that value in FOCUS then it's not summing those fraction values.

Ex:

Table A --> column A - value might be 0.45

Webfocus treats that value as 0.

Is there a way to get this fraction value?

my code look like

SQL

SELECT COLUMNA FROM TABLE;

TABLE FILE SQLOUT
SUM COLUMNA
END
-EXIT

This message has been edited. Last edited by: Kamesh,

What is the format of the column ?

and if you add ?FF after the TABLE FILE SQLOUT, what is the format that WebFOCUS thinks its getting ?

SQL

SELECT COLUMNA FROM TABLE;

TABLE FILE SQLOUT
?FF
SUM COLUMNA
END
-EXIT

Once we fix the master file to hold that format as P17.3, it worked.

Thanks for your help.