A field needing multiple calculations.
Attached is an example report that was not created by Crystal Reports. I am working on re-creating it in Crystal Reports.
I am using Crystal Reports 2011.
In the total line, there is a field called Coil Balance. Here is how the Coil Balance needs to be calculated:
- Add up the weight values whose Serial No does not start with B.
- Add up the Total Scrap values whose Serial No does not start with B.
- Add the results of that together and subtract from Master Coil Weight.
What is the best way to do that?