HELP!! Need to calculate a category

[Guest]

I'm working on a report and I have the following in the group footer:
TPA Reserves
TPA Payments
TPA Incurred (The Incurred is the TPA Reserves plus the TPA Payments)

I'm trying to take the TPA Incurred x 2.25

I have =Sum([TPA Reserves] + [TPA Payments]) in the controlsource which
gives me the TPA Incurred, but what else do I need in the expression to make
it multple the Incurred by 2.25?

I've tried =Sum([TPA Reserves] + [TPA Payments] * 2.25) but it doesn't give
me the correct response. Please could someone help me, I'm about ready to
pull out my hair. Thanks

 

[Al Camp]

I think you want...
= (Sum([TPA Reserves]) + Sum([TPA Payments])) * 2.25

 

[Guest]

It worked!!, Thanks sooooo much

I think you want...
= (Sum([TPA Reserves]) + Sum([TPA Payments])) * 2.25

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I'm working on a report and I have the following in the group footer:
TPA Reserves
TPA Payments
TPA Incurred (The Incurred is the TPA Reserves plus the TPA Payments)

I'm trying to take the TPA Incurred x 2.25

I have =Sum([TPA Reserves] + [TPA Payments]) in the controlsource which
gives me the TPA Incurred, but what else do I need in the expression to make
it multple the Incurred by 2.25?

I've tried =Sum([TPA Reserves] + [TPA Payments] * 2.25) but it doesn't give
me the correct response. Please could someone help me, I'm about ready to
pull out my hair. Thanks