Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

round function

OnenessboyJun 13 2011 — edited Jun 14 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2011
Added on Jun 13 2011
2 comments
141 views