HELP!! Need to calculate a category

A

acomphenn

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
 
A

acomphenn

It worked!!, Thanks sooooo much

Al Camp said:
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


acomphenn said:
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
Click to expand...
Click to expand...
 
Top