Income Statement

[billybragg]

There are 5 main groups in an income statement, and 2 important "subtotals." The trick is, the subtotals require addition AND subtraction, so a straight running total field doesn't work. Basically, if our groups are A,B,C,D and E, we need a subtotal after group B which calculates Sum(A)-Sum(B) (EBITDA), and another subtotal after group E which calculates Sum(A)-Sum(B)+Sum(C)-Sum(D)-Sum(E) (Net Earnings).
What I have tried is this: creating an invisible field in the details section which reverses the signs for values in groups B,D and E, and then calculating a running total on that value in Group A's footer. Oddly, the values in this running toal field are correct in Groups A, C and E, but not in B or D.
So, am I using the running total incorrectly? Is there a better way to do this? Has anyone ever tried to calculate EBITDA and Net Earnings? Thanks for any help.

 

[billybragg]

Correction. I placed the running total field in the footer for Group 1 (Groups A-E). Thanks again.

 

[IanNav]

BillyBragg,

I'm really new to crystal reports myself, but i might have an idea of how you can get more constant values from your data

basically i've needed to mess about with running totals on my reports, (but not with as many groups...)

What you could explore (i don't really know alot about this, i've only been doing crystal reports for 4 days)

create some formulas in the header's and footer's of your groups, the formula in the header will act as a var$ reset, and the one in the footer will be a manual running total.

You can add subtract and test each value and give yourself more control by doing this

I would use the "WHILEPRINTINGRECORDS" funtion.

Anyway, i hope this helps a little...

maybe one of the expert will come and help you. (i'm no export)

Cheers

Ian