Sum Logic for Report

[Qualinwraith]

I have a report that takes money values form several records and sums them up in various category's making a list of departments with the total amount of balance for each (positive and negative numbers). I need to categorize the positive values form the negative and calculate the totals of each and the grand final total (invoice style)

 

[Pat Hartman]

You can add two controls to the report footer. One to sum the positive values and one to sum the negative.

txtPositive
=Sum(IIf(YourAmt > 0, YourAmt, 0))
txtNegative
=Sum(IIf(YourAmt > 0, 0, YourAmt))