CR 8.5 - Summing a Calculated Field

[1cutedimple]

Hello,
I'm using the following formula to calculate a dollar figure for each person in a group:
if {@Pene Rate} >= 57 then
{@Total Life Insurance} * 25
else {@Total Life Insurance} * 0

How can I get the sum of the dollar figure for the entire group?

 

[synapsevampire]

Adjustment to the formula:

if {@Pene Rate} >= 57 then
{@Total Life Insurance} * 25
else
0

If you have this formula in the details section, then right click it and select insert->summary and select the sum and for the group of interest.

If the Insert doesn't show up, then the formulas referenced within this formula are preventing it, so you'd have to post those formulas for someone to help.

If you reference formulas within a formula, it's generally a good idea to post what's in the underlying formulas as well.

-k