Balance sheet in Crystal reports

[sergeyboukovsky]

Hello everybody,

I need to create a balance sheet and the source data is like the following:
AccountNumber Period Balance
------------------------------------
123001 1 +4000.00
123002 1 +1000.00
.
.
129001 1 -3000.00

How can I calculate, for example, the [123]+[124]-[127]-[129]? In other words, how can I add and subtract the subtotals in different groups of the same level?

Thank you in advance.

 

[synapsevampire]

That would depend upon how these subtotals are cerated.

Try right clicking the field and selecting sum

Unless what you meant to state was that this is a sample of a summary report that you created, not the source data.

Providing technical information is key.

Crystal version?
Database and connectivity used?
REAL example data?
Expected output?

-k

 

[synapsevampire]

That should be:

Try right clicking the field and selecting insert summary sum