We want to add a formula to our crystal report where in a group if a specific value exists then add that amount to the largest amount in that group.
As in below example our invoice group by the vehicle registration number.
In second group we want to add the Administration Fee to the Largest Fee in that group, like I want to sum both administration fee (20 + 20) to the largest amount (285) and also hide both administration fees.
Can some one help me to achieve this?
I shall be thankful to you.