count formula
count formula
(OP)
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.
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.
Talk To Other Members
RE: count formula
numberVar My_variable
My_variable := My_variable + {DB.Field Name}
Hope this helps,
Kevin
RE: count formula
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
RE: count formula
Robbert