running total
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11633
Printed Date: 27 Apr 2024 at 3:13am
Topic: running total
Posted By: tatanka
Subject: running total
Date Posted: 09 Nov 2010 at 6:53am
Hi everyone.  Can you help me please because i have a problem with my project. I have fields like date and sales quantity date quantity 06/10/2010 100 10/10/2010 200 15/10/2010 250 16/10/2010 300 I want to make a formula to calculate the running total for a specific date. For etc. when i give a parameter to bring me the sales quantity from 10/10 to 16/10 my running total i want to show me the quantity from previus date like 06/10. Previus Sales is 100 (from 06/10) and the current sales is 750(from 10/10 to 16/10. |
Replies:
Posted By: DBlank
Date Posted: 09 Nov 2010 at 8:04am
|
depends on your param
but basically just create RTs that uses an evaluate formula.
for the previous sales
table.Date<{?BeginDate}
for current sales
table.date in ?begindate to ?enddate
|