count formula

[skrobbert]

Hello
I'm starting to learn the formula's of Crystal Reports. I have version 8 and I can't figure out how to make a specific formula. I have a report grouped by region. Imagine there are 5 organisations in a region. Behind every organisation stands the sales amount of last year. I want to make an field behind that amount that shows the amount of that organisation added to the previous amounts in that group. Example:

Region A

organisation amount (this must be my formula)

organisation A $ 1500 $ 1500
organisation B $ 1000 $ 2500
organisation C $ 2000 $ 4500

Region B

................(etc.)

Can you please help me by creating me this formula. I can't figure it out. Thank you,

Robbert van Spronsen.

 

[ktighe]

I'm not too sure about the crystal syntax, but I think you can do it like this (maybe someone else can verify this...):

numberVar My_variable
My_variable := My_variable + {DB.Field Name}

Hope this helps,
Kevin

 

[MalcolmW]

numberVar My_variable ;
My_variable := My_variable + {DB.Field Name}

Just make sure that you end each line with a semi colon. You could also use a running total - right click on the field name, and select running total from the popup menu. Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[Thanks]

Thank you all. It worked great, exactly how I wanted it.

Robbert