New Variable 1

[funkmonsteruk]

I have a quite complicated new variable which i need to insert into a BO report, it is to calculate a scale fee and it is based on 3 fields.
<Value> - an amount in pounds
Staff Estate - (yes or no)
Complexity - (one of three choices - s, m or c)

Basically the fee is calculated based on the complexity field for s <complexity> scale fee is 4% of first £250,000 of Value and 1% of the remainder
for m <complexity> scale fee is 5% of first £250,000 of <value> and 1% of the remainder
for c <complexity> scale fee is 6% of first £250,000 of <value> and 1% of remainder

And finally for all <complexity>'s if <Staff Estate> is Yes then 30% must be deducted from scale fee......

I seem to be getting bogged down and think i've hurt my brain trying to calculate this, can anyone help.

 

[MikeMcErlain]

Try this ....

=If <complexity> = &quot;s&quot; and <StaffEstate> = &quot;Yes&quot; then (250,000*(.04*.3)) + (<value>-250000)* 0.01 else If <complexity> = &quot;s&quot; and <StaffEstate> = &quot;No&quot; then (250,000*.04) + (<value>-250000)* 0.01 else If <complexity> = &quot;m&quot; and <StaffEstate> = &quot;Yes&quot; then (250,000*(.05*.3)) + (<value>-250000)* 0.01 else If <complexity> = &quot;m&quot; and <StaffEstate> = &quot;No&quot; then (250,000*.05) + (<value>-250000)* 0.01 else If <complexity> = &quot;c&quot; and <StaffEstate> = &quot;Yes&quot; then (250,000*(.06*.3)) + (<value>-250000)* 0.01 else If <complexity> = &quot;c&quot; and <StaffEstate> = &quot;No&quot; then (250,000*.06) + (<value>-250000)* 0.01

I'm not sure if I have the 30% correct but you get the idea!

Mike McErlain
Cypress eBI, Inc.
MikeMcErlain@hotmail.com

 

[funkmonsteruk]

Cheers Mike, this is a lot of help