Hi all,
I have report attached to form and that report has below formulae column like this..
function CF_***_saving return Number is
begin
return :CF_days_difference * (:CF_savings * 1000)/365;
end;
function CF_savingsFormula return Number is
begin
return round(nvl(:claim_savings,0)/1000);
end;
function CF_days_differenceFormula return Number is
begin
return round(:settled_date) - round(:effective_date);
end;
and i placed field on layout with below format mask
NNN,NNN,NNN,NNN,NN0
Now when i run the report data is being displayed as : 295890.41096
but i need to round it fully so that i dont want to diplay any deciman in place.
even though i have code of
return round(nvl(:claim_savings,0)/1000);
its not doing full rounding function...
any suggestion please..
asp