Dear All
I am facing the problem of running total group wise. I have one query which finding the balance.
Balance is calculated through the formula column.
I want the output like this :
Group A :
Ref No. IN Qty. Out Qty. Bal. Qty
1 2.0 0.0 2.0
2 2.0 0.0 4.0
3 0.0 1.0 3.0
Group B :
Ref No. IN Qty. Out Qty. Bal. Qty
4 2.0 0.0 2.0
5 2.0 0.0 4.0
8 0.0 1.0 3.0
Can u help for this.
Samit Gandhi
Samit Gandhi
Problem in Running Total
-
- Posts: 2
- Joined: Wed May 10, 2006 7:43 am
- Location: Hong Kong
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
If you dont mind will you send me report???? at mirza_rehan@yahoo.com and cc to rehan.mirza@unionexp.com to i will modified it as yours need also send me table structure query...
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Create to (2) summery items in same frequency where In_Qty and Out_Qty exist for example sum_InQty and Sum_OutQty Set Reset At property as its above group.. now create farmula column cf_Balance at same same frequency of above items now write code in farmula columns
<b>function CF_BalanceFormula return Number is
CBal Number;
begin
CBal := Nvl(:Sum_InQty,0) - Nvl(:Sum_OutQty,0);
Return(CBal);
end;</b>
hope it will solve yours problem... if still problem please mail me yours report at mirza_rehan@yahoo.com and cc to rehan.mirza@yahoo.com
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
<b>function CF_BalanceFormula return Number is
CBal Number;
begin
CBal := Nvl(:Sum_InQty,0) - Nvl(:Sum_OutQty,0);
Return(CBal);
end;</b>
hope it will solve yours problem... if still problem please mail me yours report at mirza_rehan@yahoo.com and cc to rehan.mirza@yahoo.com
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Who is online
Users browsing this forum: No registered users and 0 guests