briankam
asked on
My formula won't sum in Crystal Reports
I have a formula that displays only the quantity from a customer's most recent order.
Part 1: Find the Max OrderNo for the customer. Using the Running Totals Fields it finds the max OrderNo and evaluates on Change of CustomerNo and resets on Group 2)
Part 2: If OrderNo = MaxOrderNo then OrderQty else 0. Using Formula Fields with the MaxOrderNo derived from Part 1
Problem: I need to sum the column of data created by my two part formula, but Crystal is not allowing a cummulative sum on the formula. I need to sum both the group 2 and the report grand total. Thank you for any help
Part 1: Find the Max OrderNo for the customer. Using the Running Totals Fields it finds the max OrderNo and evaluates on Change of CustomerNo and resets on Group 2)
Part 2: If OrderNo = MaxOrderNo then OrderQty else 0. Using Formula Fields with the MaxOrderNo derived from Part 1
Problem: I need to sum the column of data created by my two part formula, but Crystal is not allowing a cummulative sum on the formula. I need to sum both the group 2 and the report grand total. Thank you for any help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.