Urgent Help Needed !!!

G

Gwen H

I have a report with group totals. In one field (groupPortfolioAmt) of the
group totals, if the value of another field (groupPortfolioNo) is greater
than zero, I want to sum groupPortfolioAmt. If not, I want to just print 0 in
groupPortfolioAmt. Why is the following code in the Control Source property
for groupPortfolioAmt not working?

=IIf([groupPortfolioNo]>0,(Sum(Abs([portfolioAmount]))+[Sum of
portfolioAmount])/2,0)

Help me! I need to fix this today!

Many thanks!
 
K

Ken Snell \(MVP\)

Not sure, but perhaps this:

=Sum(IIf([groupPortfolioNo]>0,Abs([portfolioAmount]),0))+[Sum of
portfolioAmount])/2,0)
 
Top