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





Make the world a better place.

Adding in a Crystal formula

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

    • Nicole McMorrow
    • Top 50 Contributor
    • Posts 116
    • 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 D. 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
    Friends of Bassett, Inc.
    607/547-3081

    Donate Now! https://www.friendsofbassett.org/fob.php

    Bassett Healthcare: Right Where You Need Us

    Bassett Healthcare, A network of 5 Hospitals and over 25 Health Centers, offers the finest medical care to residents of rural Central New York
  • 07-23-2009 11:55 AM In reply to

    • Patrick Manning
    • Not Ranked
    • Posts 12
    • 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.

  • 07-23-2009 12:09 PM In reply to

    • Nak
    • Top 500 Contributor
    • User Since: 1999
    • Posts 23
    • 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.
Page 1 of 1 (4 items)