Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Dec 2001
    Location
    Rickmansworth, Hertfordshire, United Kingdom
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I now need to sum the conditional amounts described in the thread below. If I take the expression =IIf([GiftAid]=True,[Amount Pledged]*1.28) and wrap =Sum(...) around it I get =Sum(=IIf([GiftAid]=True,[Amount Pledged]*1.28)) which doesn't work - no error message but the expression disappears as the control source after the attempt. Suggestions?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Roger,

    You need to SUM the field that the conditional expression is located in.

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by roger trigg View Post
    =Sum(=IIf([GiftAid]=True,[Amount Pledged]*1.28))
    You only use one = sign so:

    =Sum(IIf([GiftAid]=True,[Amount Pledged]*1.28))
    Regards
    John



  4. #4
    Star Lounger
    Join Date
    Dec 2001
    Location
    Rickmansworth, Hertfordshire, United Kingdom
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many thanks, John, that did it! Have a long, cool one on me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •