Click here to Skip to main content
11,715,425 members (80,782 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: CrystalReports
Current Day: Opening Balance 1000 Dr

Debit Credit

500 100

Closing Balance 1400
My Calculation 500 100 --> i got a output this one- output was not correct

Daily Total(Sum) 1500 1500 --> this output was correct

Next Day Opening Balance 1400 Dr

I need daily total amount tally to particular transaction.
Posted 23-May-13 0:53am
Kschuler at 23-May-13 12:11pm
Please explain more. What I'm reading is that you start with 1000. Then you Debit 500 and Credit 100. Which to me means 1000-500+100=600. So how could 1400 be the closing balance? What calculations are you actually using? And what are you actually asking for? A crystal reports formula? Or what? Click the Improve question link and give us more information so we can help you.
NathiShariq at 25-May-13 1:35am
simply started with 1000 rs debit. first check the opening balance debit or credit. if debit means use a formula opening balance+debit-credit. otherwise opening balance-debit+credit.check the crystal report formula link
Kschuler at 29-May-13 8:42am
That didn't clarify anything for me. I understand the formula...I just don't understand your data and what you are expecting to happen. If you want help, you're going to have to clarify and step us through what you are doing using complete sentences so we know what you are talking about.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 485
1 Richard MacCutchan 275
2 Maciej Los 259
3 ManasKumarM 155
4 Frankie-C 125
0 Sergey Alexandrovich Kryukov 785
1 CHill60 415
2 Richard MacCutchan 405
3 Maciej Los 389
4 OriginalGriff 320

Advertise | Privacy | Mobile
Web03 | 2.8.150901.1 | Last Updated 23 May 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100