ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I am attempting to calculate an award payout based on two dynamic input values. I am trying this via the calculation object within a transformation. I have tried the following but cannot get it to work. Any help is appreciated.

begin
if (StrToFloat([F001])/StrToFloat([F002]))*100 is >= 90 and < 95 then
Result := (StrToFloat([F001]) * .01
else if (StrToFloat([F001])/StrToFloat([F002]))*100 is >= 95 and < 100 then
Result := (StrToFloat([F001]) * .01125
else if (StrToFloat([F001])/StrToFloat([F002]))*100 is >= 100 and < 105 then
Result := (StrToFloat([F001]) * .0125
else if (StrToFloat([F001])/StrToFloat([F002]))*100 is >= 105 then
Result := (StrToFloat([F001]) * .015
else
Result := 0
end;

Thanks

You have made it far too complicated

begin
if ([F001]/[F002])*100 >= 90 and ([F001]/[F002])*100 < 95 then
Result := [F001] * 0.01
else if ([F001])/[F002])*100 >= 95 and ([F001])/[F002])*100 < 100 then
Result := [F001] * 0.01125
else if ([F001]/[F002])*100 >= 100 and ([F001]/[F002])*100 < 105 then
Result := [F001] * 0.0125
else if ([F001]/[F002])*100 >= 105 then
Result := [F001] * 0.015
else
Result := 0;
end;

Start from simple than slowly increase complexity

Mike