Add to If Then Else Statement CR 9 1

[VickieT]

Hello

I am using CR9 and am working with health plan benefits and deductions. This particular request was for insurance volume (for example, basic life insurance, the volume would be the max amount it would pay if an employee dies). The different plans calculate differently mostly based on salary and the office that generates these amounts wasn’t putting them in a certain field, I had to calculate them. The formula I have was working fine but now for the codes “baslf” and “ad&d” where the employee reaches age 65, 70, 75 their insurance gets reduced by 35%, 25%, 15% respectively and it is reflected in the {ESYEMBDD.BEN_NUMERIC_OPER} field which you’ll see at the end of my If then statement. I need to incorporate this into my formula somehow so that if an employee is at one of these ages (I can use their birthdate) it looks in that field for the volume instead of using the @round50000 formula.

Any help you can give is, as always, very much appreciated.

Current formula

If {ESYEMBDD.BENDED_CODE}= "ltd" then
(
if {@ltdvolume} >= 3500 then 3500
else
{@ltdvolume}
)
else
If {ESYEMBDD.BENDED_CODE}= "std" then
(
if {@stdvolume} >= 1000 then
1000
else
{@stdvolume}
)
else
If {ESYBDPNH.BENDED_CODE}= "ad&d" then {@Round50000} else
If {ESYBDPNH.BENDED_CODE}= "baslf" then {@round50000}else
{ESYEMBDD.BEN_NUMERIC_OPER}

-----------------------------------------------------------------------------------------
4 formulas used inside the current formula:
@Round50000 formula
If round({@annual salary} * 2 + 499.9999999,-3) >= 50000 then 50000 else
round({@annual salary} * 2 + 499.9999999, -3)

@Annual Salary formula
if {ESYAPPTR.SHIFT_CODE} = "112" then {ESYAPPTR.HOURLY_RATE} * 112 * 26 else
{ESYAPPTR.HOURLY_RATE} * 80 * 26;


@ltdvolume
(({@annual salary} / 12) * .60)

@stdvolume
(({@annual salary} / 52) * .60)

TIA
Vickie

 

[synapsevampire]

I don't understand where the ESYEMBDD.BEN_NUMERIC_OPER is being used against any amounts.

Here's a good article on calculating an age:

http://www.kenhamady.com/form06.html

You seem to be a good coder, the rest of it seems fairly straightforward, let's hear if you need more help.

-k

 

[VickieT]

Hi Synapsevampire

If I seem to be a good coder, I owe it to you guys because you all make me look so good and I greatly appreciate you all!

The ESYEMBDD.BEN_NUMERIC_OPER is the field where my customer is putting the reduced amounts for those ages manually so they don't have to be calculated and she wishes Crystal to look in that field for the amount if their ages fall between 65 and 75. Hmmm I think in typing my answer to you I found my answer. Thanks.