Skip to Content
avatar image
Former Member

ADDING THREE SUM FIELDS (THREE COLUMNS)

Hello and I'm making progress with CR.  I'm working on using the sum function for three columns, this is my setup.the three columns representing bills each column for a different company. I have used the summary function (min) for a total in the report footer, having problem with the sum function to add all three summary functions together. this is the code that's in the formula workshop. the Form workshop sees no problem with the function,, when inserting the field in the footer I only get 0

CURRENCYVAR_DEBT;

//SUM({_DEBT.CCBAL1}+{_DEBT.CCBAL2}+{_DEBT.CCBAL3});

Any help would be appreciated and have a good evening

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 15, 2015 at 08:51 AM

    Hi PW,

    Are you trying to sum the min values on the footer or sum the database fields and display the summary on the footer?

    If you're trying to add the three fields and display the summary on the footer, here's what you need to do:

    SUM({_DEBT.CCBAL1})+Sum({_DEBT.CCBAL2})+Sum({_DEBT.CCBAL3});


    In the formula editor, make sure that the option 'Default Values for Nulls' is selected from the drop-down on the top.


    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      That did it, thanks again and to think that I was attempting to set a MS spreadsheet up for this, wish I knew about CR years ago.  Have a good day