sum a custom field

[heathlovell]

Hello,
I have report that lists employee vacation hours and their pay rate. I created a field ("Text19) on each line that takes the two fields and multiplies them together. This works fine. I am trying to sum this field over the whole report. I have tried =sum([Text19]) but when I run the report it pops up an input box asking for Text19. Thanks for any help,
Heath

 

[mp9]

Let's say the two fields Text19 multiplies together are called PayRate and VacationHours. Have you tried

=Sum(([PayRate]*[VacationHours]))

??

http://www22.brinkster.com/accessory/

 

[MichaelRed]

mp9,

hopefully not

e.g.

? 9 * 5
45
? 6 * 11
66
? 15 + 16
31
? (9 * 5) + (6 * 11)
111
MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[MichaelRed]

heathlovell

A way is to include the detail calculation in the report recordsource (query?). Then, just do the sum on the new (calculated) field (you can also use it to display the value in the detail section for each individual).

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[mp9]

Michael

Logically so, surely. Brackets within the Sum() should be processed first, so ([PayRate]*[VacationHours]) should get calculated first and the result of this calculation should then be considered by the Sum().

However, logic seems to have gone out the window as this returns #Error instead...

http://www22.brinkster.com/accessory/

 

[mp9]

Sorry - if you put the formula from my first post in the the report header or report footer it works correctly (e.g. it correctly returns 111 in Michael's example). It's only if you put the text box with the formula in the page footer, as I stupidly did whilst testing, that you get the error.

HTH

http://www22.brinkster.com/accessory/

 

[heathlovell]

Thanks for the tips. I will try your suggestion. I have been pretty busy. As soon as I find out, I will let you know.

Thanks,
Heath

 

[heathlovell]

Hello,
I have tried to re-create the expressions in the query, but one (vacation time used) used a Dsum to look up how much vacation time the employee has used. I can't get the criteria section to work. I need the employeeID for each record in the query to match employeeID in the attendance table, but I don't know how to do this. Thanks for the help,
Heath