need help in totaling expression

[Luckydvl]

first of let me say hi to everyone, it my first time here so i am n00b, so dont get mad if i ask a dumb question u got to bare with me. well here it goes. i have a equation in my report that is written like this

=Int((Count([product])/4)+0.9) what it doesn is it counts the total sample and devides it by 4 thats the ovious, but at the end of my report in the product footer i want to get a total of the counts that it did for example

the expression had result that where 5,3,5,2 i would like to total the whole thing so it would be 15 but how do i right the expression to still do the equation and total at the product footer so any help would be cool
thx

 

[RichO]

Did you try:

=Sum(Int((Count([product])/4)+0.9))

 

[Luckydvl]

tried that and it comes up with a error that sayss

cannot have aggregate function in expression

But thanks for the help, anyone else

 

[Luckydvl]

still have no luck tried all kinds of stuff anyone else god idea on how i can get this total think to work

 

[RichO]

Does this part work for you though (in the detail section)?

=Int(Count([product])/4)+0.9))

 

[alastair69]

still have no luck tried all kinds of stuff anyone else god idea on how i can get this total think to work

Have a look for "RptSampl.exe" it has a list of problems with answers "How to Sum a Column of Numbers in a Report by Page".

Hope this is on use to you.

Alastair

 

[Luckydvl]

yes the original expression works, it calculates but when i try to get it to count on the footer the total it won't

 

[RichO]

OK give this a try...

Right next to your textbox that currently contains the expression

=Int((Count([product])/4)+0.9)

add another textbox with the same exact expression and make it non-visible. Then set the Running Sum property for this text box to Over All. Give this text box the name "txtRunSum".

Then in your footer, add a text box and set its control source to
=[txtRunSum]