Problem in Running Total

[samit_gandhi]

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

[mirza_rehan]

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

[mirza_rehan]

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