| how to use subtraction in report builder? [message #85952] |
Mon, 16 August 2004 16:08  |
agnes
Messages: 13
Registered: February 2004
|
Junior Member |
|
|
how to deduct the number value in report builder?where it only consist sum, average,total,count... so how can you help me? how can you help me if i want to use subtraction in report builder!!
for example :
amount allocation - payment amount
so can you please help me!!! i rely need your help!!
thank q
|
|
|
|
| Re: how to use subtraction in report builder? [message #85953 is a reply to message #85952] |
Mon, 16 August 2004 21:38  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
One way is to do this in your Report query itself e.g.:
Select empno,(sal-nvl(comm,0)) Diff from emp;
Other way can be make a Formula Column e.g.
Declare
L_Diff Number(10):=0;
Begin
L_diff:=sal-nvl(comm,0);
return(L_diff);
excpetion
when others then
L_diff:=0;
return(L_diff);
end;
And then use this formula coulmn to display value on the layout.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
