<div>
Create a formula<br />
<br />
In the FIELD EXPLORER right click FORMULAS<br />
Click NEW<br />
Name - Calc_MPG<br />
Formula - note select fields from the fields in report tree<br />

<pre><code class="code-1 nolinks" id="code-20-42053625-1"><span>{MilesField} / {Gallons Field}</span>
</code></pre>
Click SAVE AND CLOSE<br />
Drag the formula onto the report just like you do a database field<br />
Format as desired<br />
<br />
mlmcc
</div>


<div>
Now that I look at the report that will not work. &nbsp;The problem is with the report summing &nbsp;3 fields. &nbsp; &nbsp;We enter this info on a form in our accounting system. &nbsp;We always enter all miles into only one of these 3 fields but the report is using a sum of all three fields to give a result. &nbsp;I will need to know how to divide the sum by the no. of gallons.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/03_w12/1151709/Screen-Shot-2017-03-20-at-8.43.06-AM.png" target="_blank" class="file-inline" title="1 (38 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Screen-Shot-2017-03-20-at-8.43.06-AM.png</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2017/03_w12/1151710/Screen-Shot-2017-03-20-at-8.45.23-AM.png" target="_blank" class="file-inline" title="2 (35 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Screen-Shot-2017-03-20-at-8.45.23-AM.png</a>
</div>


Screen-Shot-2017-03-20-at-8.45.23-AM.png

Screen-Shot-2017-03-20-at-8.43.06-AM.png

<div>
It will be something like this<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42056015-1"><span>(Sum(MilesField1) + Sum(MilesField2) + Sum(MilesField3)) / Sum(FuelField)</span>
</code></pre>
<br />
mlmcc
</div>


<div>
OK &nbsp;I got that part, but now it gives me a division by zero number.
</div>


<div>
I'm sorry, it gives me a &quot;division by zero&quot; ERROR
</div>


<div>
Thank you that worked. &nbsp;I have 1 more problem I just realized. &nbsp;On the screenshot attached, look at the the field of &quot;On Road&quot; and go down the page until you find the number of 471. &nbsp;That is the on road miles for this unit number. &nbsp;The problem is the no. of gallons. &nbsp;It shows &quot;0&quot; &nbsp;That is not actually correct. &nbsp;The only reason the report is showing &quot;0&quot; is because that was the 1st entry entered for that unit number (there were no gallons for the first entry). &nbsp;In the accounting system their are 5 entries. &nbsp;The report will only show the first. &nbsp;Can you help me figure out how I can get the &quot;no. of gallons&quot; field to be a sum of all the gallons for each unit number?<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/03_w12/1151749/Screen-Shot-2017-03-20-at-11.40.41-A.png" target="_blank" class="file-inline" title="1 (106 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Screen-Shot-2017-03-20-at-11.40.41-A.png</a>
</div>


Screen-Shot-2017-03-20-at-11.40.41-A.png

<div>
Do you have a group on the equipment number or field?<br />
If so show it as a sum over the group rather than the field<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42056290-1"><span>Sum({FuelField}, {Equipment Field})</span>
</code></pre>
<br />
If you don't have a group then add a group on the equipment field then do the sum<br />
<br />
mlmcc
</div>


<div>
How do I check if I have a group?
</div>


<div>
Look at the report in design mode<br />
If there are groups you will see GH1, GH2, etc<br />
Hover over the group in the left margin and you will see the field it is based on<br />
<br />
Another way is through the REPORT menu<br />
<br />
REPORT --&gt; GROUP EXPERT<br />
Groups will be listed in order<br />
<br />
mlmcc
</div>


<div>
Here is what it shows in group expert. &nbsp; How would I write the sum now?<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/03_w12/1151965/Screen-Shot-2017-03-21-at-7.48.05-AM.png" target="_blank" class="file-inline" title="1 (17 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Screen-Shot-2017-03-21-at-7.48.05-AM.png</a>
</div>


Screen-Shot-2017-03-21-at-7.48.05-AM.png

<div>
Are the 5 fuel entries in the same record or are they separate records?<br />
<br />
You have a group on equipment.<br />
<br />
mlmcc
</div>


<div>
Hope I can explain this. &nbsp;On the form in the accounting system you enter in a sequence number and than the info for a piece of equipment. &nbsp;After you are done you click on an arrow button and it drops you to the bottom of the page (maybe it's a subform) and you enter in the miles, and the number of gallons. &nbsp;After that you click another arrow key it puts you at the top of the page and you enter another sequence number but if you have more entries for the piece of equipment you typed in previously you will enter those as well and keep doing this procedure until you are finished with that piece of equipment. &nbsp; So you could have 5, 10, 15, etc... miles and gallons info to be entered for 1 piece of equipment. &nbsp;Each time you enter in some information on that piece you will have to enter in a sequence number. &nbsp;Sorry if this is confusing. &nbsp; See screenshot.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/03_w12/1151999/Screen-Shot-2017-03-21-at-8.35.16-AM.png" target="_blank" class="file-inline" title="1 (87 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Screen-Shot-2017-03-21-at-8.35.16-AM.png</a>
</div>


Screen-Shot-2017-03-21-at-8.35.16-AM.png

<div>
Without more information on the data structure I am working blind.<br />
<br />
Try this <br />

<pre><code class="code-1 nolinks" id="code-20-42058724-1"><span>If Sum({FuelField},{Equipment}) = 0 then</span>
<span>    0</span>
<span>Else</span>
<span>    (Sum({MilesField1},{Equipment}) + Sum({MilesField2},{Equipment}) + Sum({MilesField3},{Equipment})) / Sum(FuelField,{Equipment})</span>
</code></pre>
<br />
mlmcc
</div>


<div>
I'm getting a bit confused now. &nbsp;Do you know if experts exchange would have someone that could freelance for a fee to help me with this? &nbsp;Or are you available for that sort of thing?
</div>


<div>
There are several new features for that.<br />
&nbsp; &nbsp;GIGS - Full projects experts can provide estimates<br />
&nbsp; &nbsp;LIVE - Live help at a agreed on rate per hour - done through some terminal sharing app on EE<br />
<br />
If you hover on the 3 dots next to ASK A QUESTION you will see the options<br />
<br />
I won't be available until the weekend, fully engaged with a client right now.<br />
<br />
mlmcc
</div>


<div>
I don't know if any of the other Crystal experts are open to Gigs or Live help.
</div>


<div>
Are you still looking for help with this?<br />
<br />
I can be available later this week<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
I have used Crystal Reports only a couple times but need some assistance with dividing two fields. &nbsp;I have a Crystal report created and there are 2 fields: &nbsp;1 is Miles and the other is Gallons. &nbsp;What I want to do is divide these 2 fields and have it give the result in another field which I would label MPG. &nbsp;WHat is the best way to do this? &nbsp;I will probably need step by step instructions.
</div>
</div>


I have used Crystal Reports only a couple times but need some assistance with dividing two fields.  I have a Crystal report created and there are 2 fields:  1 is Miles and the other is Gallons.  What I want to do is divide these 2 fields and have it give the result in another field which I would label MPG.  WHat is the best way to do this?  I will probably need step by step instructions.

crystal reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.