Skip to main content
October 30, 2009
Question

Sum function in Coldfusion report builder?

  • October 30, 2009
  • 1 reply
  • 1754 views

Has anyone ever used the sum function (to sum up a column) in Coldfusion report builder?  If so, do you have an example of how it works?  i've tried several options and none have worked so far.  I keep getting the error the sum() is not a ColdFusion function.

    This topic has been closed for replies.

    1 reply

    Participant
    January 20, 2011

    I have gotten this to work. See Adding a calculated field section of Creating a simple report page on Adobe livedocs

    http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=reportBuilder_19.html

      1. Choose Window > Fields and Parameters.
      2. Report Builder displays the Fields and Parameters panel.
      3. Expand the list of calculated fields.
      4. With Calculated Fields selected, click the (+) button at the upper edge of the Fields and Parameters panel.
      5. Make the following changes in the Add Calculated Field dialog box:
        1. Change the name of the calculated field.
        2. Change the label text.
        3. Change the Data Type to Float.
        4. Change the Calculation to Sum.
        5. Enter the field you wish to sum.
      August 25, 2011

      Thanks.