AnsweredAssumed Answered

Problem with a calculated result using a summary field

Question asked by SteveH on Jan 29, 2014
Latest reply on Jan 29, 2014 by philmodjunk

Title

Problem with a calculated result using a summary field

Post

     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.

     Thanks!

      

      

Outcomes