[RESOLVED] CR 11 Formula Question

[Besoup]

Is there a way I can multiply by the number of records on the report?

[shakti5385]

Send Ur table Format

[Besoup]

huh?

[King_George]

huh?

Can you give some more detail as to what you're trying to do?

[Besoup]

Ok I have a report that displays a bunch of employee records and what they contribute to some weekly office pool. Everyone puts in $.50 and I need to display that in the details with everyone employee name. Then I need to have a total of the contributions on the footer...

[King_George]

Ok I have a report that displays a bunch of employee records and what they contribute to some weekly office pool. Everyone puts in $.50 and I need to display that in the details with everyone employee name. Then I need to have a total of the contributions on the footer...

The easiest way I can think of would be to group by employee and have a group total in the group footer.

HTH

[Besoup]

The easiest way I can think of would be to group by employee and have a group total in the group footer.

HTH

I would do that if I could get a sum on my formula field... I tried making a fomula field with the value .50 and for some reason when I go to make a sum it won't show up in the list of fields....

[mabbas110]

there is one shortcut for this .

put a text field with value .50 in front of each employee

then at the footer put a formula filed in which u multiply the recordnumber field ( u can get this field from insert -> special fields ) with the .50 , and by this u can get the correct value

thanks

[Besoup]

thnx