I currently have a fuel database with 3 tables. Which tracks fuel we receive (Diesel and Gasoline) as well as fuel consumed.
Shop Fuel_Odometer (copy of Shop Fuel)
I recently added a new filed labeled "Fuel In Tank" which is used when the tank is measured for the amount of fuel left in it for reconciliation. I am trying to create a reconciliation which takes the last "fuel in tank" entry - sBalance (which is a balance of what we show should be in the tank) and the result would be the difference from the two.
I have tried using ''Fuel In Tank'' - sBalance in a Summary by Fuel Type Part but it isnt resulting in what I need.
Any help on this matter?