I can not get this global function to return useful info....am I missing something?

Hi,

This is my first fucntion...so please be kind! I am calling this function in the product table:

adjustPriceFromEbayUK('UK Price Ebay', "EUR", 'Postage Type (One Item)', "", SKU)

It does not look like it is pulling through the values in the select statements. In the console they are there but the result is always 0.95 (created by the the floor statement at the bottom of the code) when I run it from the form on the Products table. 'UK Price Ebay' value also does not return a value even though it is past in the function header. I think I am fundamentally missing something.

Any thoughts?

Thanks

Matt

function adjustPriceFromEbayUK(ebayUKprice : number,my_currency : text,my_postage_type : text,mySource : text,myProduct : text) do

"---This function takes the eBay UK price and adjusts it for postage type and weight and translates it to other currencies---";
let postage_adjustment := 0;
let myweight := (select Products where SKU = myProduct).'Weight (g)';
if ebayUKprice = null or ebayUKprice < 0.1 then
0
else
"---Add an additional amount based on currency---";
if my_currency = "EUR" or my_currency = "SEK" or my_currency = "CHF" or my_currency = "PLN" then
postage_adjustment = postage_adjustment + 1
end;
if my_currency = "NZD" or my_currency = "JPY" or my_currency = "AUD" or my_currency = "CAD" or my_currency = "USD" then
postage_adjustment = postage_adjustment + 2
end;
"---Add an additional amount based on postage type---";
if my_postage_type = "Parcel" then
postage_adjustment = postage_adjustment + 2
end;
if my_postage_type = "Large Letter (Heavy)" then
postage_adjustment = postage_adjustment + 1
end;
"---Add an additional amount based on weight---";
if myweight = null then myweight = 0 end;
if myweight > 0 and myweight <= 50 then
postage_adjustment = postage_adjustment + 0
end;
if myweight > 50 and myweight <= 150 then
postage_adjustment = postage_adjustment + 0
end;
if myweight > 150 and myweight <= 350 then
postage_adjustment = postage_adjustment + 0
end;
if myweight > 350 and myweight <= 600 then
postage_adjustment = postage_adjustment + 0
end;
if myweight > 600 and myweight <= 1000 then
postage_adjustment = postage_adjustment + 0
end;
if myweight > 1000 and myweight <= 1500 then
postage_adjustment = postage_adjustment + 0
end;
if myweight > 1500 and myweight <= 2000 then
postage_adjustment = postage_adjustment + 0
end;
"---Adjust the final total by the currency variable---";
let x_rate := first(select Currencies where Currency = my_currency).'Exchange Rate';
let result := ebayUKprice + postage_adjustment;
floor(result * x_rate)+0.95
end
end