Formula to calculate total

Melzer · Jul 30, 2001

Using crystal 7. I have two fields: Ordernum and orderamt
Problem is orderamt only caculates cumulative amounts:

Ex.: Order 1 for $100
Order 1a for $100

Comes out as Ordernum Orderamt
1 100
1a 200

I need a report that shows the actual amount of Order 1a. I've tried using a formula with Prev() which works great if I'm running a report based on Ordernum but if I need a report by date range (in the above example Order 1 is in June and Order 1a in August, I run the report only using Aug Orders) then the Prev() isn't going to work for me.

Any suggestions?

kenhamady · Jul 31, 2001

Is OrderAmt a database field, formula or running total? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

Melzer · Jul 31, 2001

Orderamt is a database field

kenhamady · Jul 31, 2001

So the table stores the cumulative amount, but not the increment? That is an unusual scenario.

If you need to calculat the increment from the cumulative amount, without having the previous record, then I don't know of a way.
You will have to keep the records together. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Formula to calculate total

Melzer

Technical User

kenhamady

Instructor

Melzer

Technical User

kenhamady

Instructor

Similar threads

Part and Inventory Search

Sponsor