|
thank you very much prathima..
it works fine but how to fetch with the open
balance amount?
i mean let say we have 23K for that account then
either it will be added or deducted, it is depending on the
transactions.
ok..there we have total amount for every
transactions on the right side.
the at the first transaction we have to look at the
opening balance for that account. 23911.58 + 682.50 = 24594.08
and this is the net amount after the first
transaction.
means, we shld started with that opening
balance.
please..
----- Original Message -----
Sent: Wednesday, December 01, 2004 11:04
PM
Subject: RE: PSC Crystal - Running
total
hey,
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.commy/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]
To unsubscribe, send an email to:
[EMAIL PROTECTED]
| Yahoo! Groups Sponsor |
ADVERTISEMENT
![click here]() | |
![Web Bug from http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=:HM/A=2376776/rand=691347357]() |
Yahoo! Groups Links
|
