Formula to Sum Multiple Checks

[Meg09]

Hi,

I am writing a report in which I need to provide a sum if the person has more than one pay check per the pay period. I can only display one total hours, net and gross per person. Unfortunately, it is not as simple as creating a formula to add multiple checks together as I am creating this report in a specified file format. Is there any way to add the word sum to my formula below? Any suggestions would be appreciated. Thanks.

Meg

& Cstr({ph_information.cur_gross},"###########",0)&Space(11-Length(CStr({ph_information.cur_gross},"###########",0)))//(11)332-342 - grosspay_A
& Cstr({ph_information.cur_net},"###########",0)&Space(11-Length(CStr({ph_information.cur_net},"###########",0))) //(11)343-353 - netpay_A
& Cstr({ph_information.total_hours},"########",0)&Space(8-Length(CStr({ph_information.total_hours},"########",0))) //(8)354-361 - hours_A

 

[IanWaterman]

Assuming this is displayed in a group footer something like

& Cstr(sum({ph_information.total_hours}, groupfield),"########",0)

replace groupfield with whatever you are using to group report.

Ian

Ian