count formula

skrobbert · Jun 7, 2001

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 · Jun 7, 2001

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 · Jun 7, 2001

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 · Jun 7, 2001

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

Robbert

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

count formula

skrobbert

Technical User

ktighe

Programmer

MalcolmW

Programmer

Thanks

Programmer

Similar threads

Part and Inventory Search

Sponsor