Urgent Help Needed !!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
It appears you forgot part of the field reference in the
abs([portfolioAmount] portion of the function, based on what you wrote for
field names, shouldn't it be?

abs([GroupPortfolioAmount] )
 
Back
Top