Results 1 to 3 of 3

Thread: sum if

  1. #1
    Join Date
    Oct 2005

    Unanswered: sum if

    I'm really new to crystal reports, but what I'm trying to do is really simple usually.

    I would like to sum the field (orders.dollarvalue) if the field (orders.complete)= true.

    I have the equation working well in access97 as:
    =Sum(IIf([complete]=true,[dollar value of order],0))

    but this doesn't seem to work in crystal. Does anyone know what the expression is that I should be using?

    Thanks for helping out a newbie

  2. #2
    Join Date
    May 2004
    Put this in a formula:

    If (orders.complete)= true then (orders.dollarvalue)

    Then sum this formula

  3. #3
    Join Date
    Oct 2005


    Thanks a lot! That worked great. I guess the formulas are different in crystal reports from access and excel.

Posting Permissions

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