Crystal Reports 10 formula help

[Former Member]

I am attempting to create a formula using multiple fields from different tables to give me an end result.

For example:

2 E 145 Paidup ago 57 2 E 87 Paidup ago 76 2 E 159 Paidup ago 45 2 E 67 Paidup ago 9

Customer.

SVCmatch.{Paidup rating}

SVCmatch.{Paidup age}

SVCmatch.{Paidup ago}

I want to create a formula so out of the 4 linked records, only the maximum paid up age is taken into account, then for it to look at that particular records' Paidup age before giving the end result. In the case above it should look at the record where the paidup age is 159, then if the paidup ago is less than 50, give me a "decline" result, if not then "accept". There wont always be multiple records for the same customer, but where there is, the unique or linked field is the customerid.

Thanks.

[Former Member · Accepted solution]

Group on customer id, then sort by paidupage, suppress group header and detail, put everything in the group footer.

Then all you have to do is put a formula there that subtracts the one field from othe other.