title: Crystal report formula for adding/subtracting value from one field to another field
body: <p>I have a report which has two fields: <code>BOX</code> and <code>TRAYS</code>, which are then summarize in each group using sum formula. And then there is a grand total of these fields are also shown. Now the problem is that I want to convert trays to boxes if their count increase from 12, and add 1 box to box field. If boxes are 2 and trays are 14 then the box field will change to 3 and trays field will change to 2. How can I achieve this?</p>