gcgcit
asked on
Sum if Value is Over Zero
I have a report with the column control source of this:
=IIf([HOURS]-[HoursRemaini ngDisplay] >0,[HOURS] -[HoursRem ainingDisp lay],0)
I need to sum that column on my report but only include the values that are over zero in that sum. What would the controlsource field for that be?
(see photo)
Right now where all the zeros displayed in this image are actually are actually storing negative values stored so I don't want them on the sum.
ee-sum.jpg
=IIf([HOURS]-[HoursRemaini
I need to sum that column on my report but only include the values that are over zero in that sum. What would the controlsource field for that be?
(see photo)
Right now where all the zeros displayed in this image are actually are actually storing negative values stored so I don't want them on the sum.
ee-sum.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
peter57r: Sorry I was making a mistake on my end that works!!! Thanks!
ASKER