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?