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