Welcome to Forums Sign in | Join | Help | Forums
in Search


Adding in a Crystal formula

Last post 07-23-2009 12:09 PM by Nova Kerjilian. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 07-22-2009 5:32 PM

    • Nicole McMorrow
    • Top 50 Contributor
    • Posts 136
    • Organization: The Women's Foundation of California
    • Products:  The Raiser's Edge, The Researcher's Edge

    Adding in a Crystal formula

    Sorry if this is a ridiculously elementary question:

    I am trying to create a formula that adds up all the instances of a particular field. I tried using running totals wizard, but I only want the grand total, not a line-by-line running total.

    Can anyone help me? Thank you!

    Nicole Decouzon McMorrow
    Development & Communications Associate
    The Women's Foundation of California
    nicolem@womensfoundca.org
  • 07-23-2009 10:32 AM In reply to

    Re: Adding in a Crystal formula

    Is this a numeric field you are trying to total? What section are you placing the total field in?

    Laurel Quaintance
    Manager, Fund Development Services
  • 07-23-2009 11:55 AM In reply to

    • Patrick Manning
    • Top 200 Contributor
    • User Since: 1997
    • Posts 45
    • Organization: College of Charleston
    • Products:  The Raiser's Edge

    Re: Adding in a Crystal formula

    There are two ways you can do this - one using a basic formula and then Grand Totalling that formula; the other way is using a variable (more complex).  Here is the basic formula:

    If {field.fieldA} = "Instance" then 1

    Insert that formula in the details section, right mouse-click on it, Insert - Grand Total.

    Patrick Manning
    Database Administrator
    Advancement Services
    College of Charleston
  • 07-23-2009 12:09 PM In reply to

    • Nova Kerjilian
    • Top 500 Contributor
    • User Since: 1999
    • Posts 33
    • Organization: Physicians for Human Rights
    • Products:  The Raiser's Edge

    Re: Adding in a Crystal formula

    Use the Summary function. It is under Insert and you can do a grand total or a total for a group.
    Nova Kerjilian
    Physicians for Human Rights
Page 1 of 1 (4 items)