Problem with a calculated result using a summary field
I have a report that shows summary total of a bunch of expenses from individual employees. Each employee has an available budget that specific to that particular employee. I want to calculate the remaining funds but so far the results FM has been giving me are incorrect.
The calculation I'm using is: Remaining = TotCost - Budget
With TotCost being a summary field of all costs. The summary field and budget both display correctly, but the "Remaining" field does not after multiple employees are entered. I'm sure I have bad logic somewhere and would appreciate any advice.