Skip to Content

Running total for two fields in Crystal Report

Hi I am using SAP BusinessObjects CrystalReports 2013 Support Pack 4

Version 14.1.4.1327 CR Developer.

I have two fields in my contract, OpeningBalance and BaseAmount.

How will I get the below format output by using running field

OpeningBalance....BaseAmount...RunningTotal

500........................100 ..................600

200...........................0......................800

400..........................0......................1200

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 20, 2016 at 03:11 PM

    Make sure 'Default Values for Nulls' is selected from the drop-down on the top in the formula editor.

    The default selection is 'Exceptions for Nulls'.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2016 at 07:49 AM

    Hi Sailee,

    Create a formula with this code and place it on the Details Section:

    shared numbervar rt;

    rt := rt + {Opening Balance} + {Base Amount};

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded