12,401,984 members (57,840 online)
Rate this:
See more:
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 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 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
http://sql2000forgp.wordpress.com/2009/09/23/crystal-report-formula/
Kschuler 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.

Top Experts
Last 24hrsThis month
 OriginalGriff 250 Richard Deeming 223 Karthik Bangalore 180 ppolymorphe 145 F-ES Sitecore 135
 OriginalGriff 7,073 ppolymorphe 3,030 Karthik Bangalore 2,917 F-ES Sitecore 2,187 Richard MacCutchan 2,125