running total can be used if u want the value based on
floating values.
Suppose u have 2 fields G1 qty and g2 qty and u want
to place one more field besides this named as total
qty.
G1qty and g2 qty u r going to fetch it from db.
Total qty is going to change based on g1qty and g2
qty.
Eq
G1qty G2qty totalQty
1 0 1(g1Qty+G2Qty+previous TotalQty)
1 1 3
1 1 5
step 1
Now create a formula F1 which will get u the summary
of G1qty and g2Qty.
step 2
Create a running Total0 where u select the field to
summarize as F1 and Type of summary as Sum.
Place this running total in detal section.
Thanks all. yr work is done
hope this would help u
prathima
--- ILyas <[EMAIL PROTECTED]> wrote:
> lets try to understand ur problem.
> in the prev email, u hv got 545 K value at the end
> of report - how did u got
> that?
>
> is this what u require?
>
> *
>
> each grp is each account with some opening bal
> *
>
> add credits and subtract debits (or) the other way
> round to the op
> bal
> *
>
> display the sum that at the eof line
>
> ILyas
>
> _____
>
> From: miss_mystikal
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 01, 2004 3:15 PM
> To: [EMAIL PROTECTED]
> Subject: Re: PSC Crystal - Running total
>
>
> what im doin is, the 23k value i got it from table1
> and every transactions
> down there i took from another table2 linked with
> acct_code as key.
> this 23k then will appear everytime if there is a
> transaction occured. place
> it right below the 23k.
> my problem is..the running total then doesnt appear
> any value.
>
> my formula is set the debit and credit as zero if
> they are null. i reset the
> runnign total in changing group.
> ilyas, can u please explain to me how to do with
> this flow?
>
> thank you.
>
>
>
> ----- Original Message -----
>
> From: ILyas <mailto:[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Sent: Wednesday, December 01, 2004 3:09 PM
> Subject: RE: PSC Crystal - Running total
>
> Did u tried writing a formula which just adds the
> cr, db values to a
> variable?
> ILyas
>
>
> -----Original Message-----
> From: miss mystikal
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 01, 2004 10:26 AM
> To: [EMAIL PROTECTED]
> Subject: PSC Crystal - Running total
>
> hi, im looking for a formula to get my running total
> in details section. at
> the group section i have my group total the
> according to the current
> transactions, i need to recalculate the running
> total. means it has to be
> changed based on every credit or debit transactions.
> there is a file that we can goin thru. can sumone
> please assist me on this?
>
> i created a formula field but i was unable to
> display the value. i need to
> place it right beside the credit field.
>
> thanks in advance.
> -miss_mystikal
>
>
_________________________________________________________________
> Using a handphone prepaid card? Reload your credit
> online!
> http://www.msn.commy/reloadredir/default.asp
> <http://www.msn.com.my/reloadredir/default.asp>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Make
> a clean sweep of pop-up ads. Yahoo! Companion
> Toolbar.
> Now with Pop-Up Blocker. Get it for free!
>
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
>
--------------------------------------------------------------------~->
>
>
> To unsubscribe, send an email to:
> [EMAIL PROTECTED]
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> To unsubscribe, send an email to:
> [EMAIL PROTECTED]
>
>
>
>
>
>
> To unsubscribe, send an email to:
> [EMAIL PROTECTED]
>
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://us.ard.yahoo.com/SIG=129cb2o30/M=298184.5639630.6699735.3001176/D=gr
>
oups/S=1705006764:HM/EXP=1101986409/A=2434971/R=0/SIG=11eeoolb0/*http://www.
> netflix.com/Default?mqso=60185400> click here
>
>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=
> :HM/A=2434971/rand=815523206>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/PlanetSourceCode/
>
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
<mailto:[EMAIL PROTECTED]>
>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
To unsubscribe, send an email to:
[EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/PlanetSourceCode/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
