Formula to calculate total
Formula to calculate total
(OP)
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?
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?
Talk To Other Members
RE: Formula to calculate total
Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
http://www.kenhamady.com/
RE: Formula to calculate total
RE: Formula to calculate total
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/