How to us Web_Category_2 as a number for calculations

Question

I am trying to tweak a product valuation to add column for shipping costs per unit. 
 I have used Web Category 2 to enter costs attributed to each product. I am now trying to get the report to calculate the figure in WEB_CATEGORY_2 by multiplying with Qty in stock. How can I change the custom box to act as a number? 
 Thank you in advance for any help offered. 
 Kind Regards

fiona wilson · Answer

Hi Melanie 
 Thanks for using Sage City 
 The following functions may be of use: 
 
 StringToFloat( variable ) - Converts alphanumeric fields to numeric fields for use in expressions and filters, when the fields contain decimal numbers. 
 
 E.g., To multiply the quantity in stock by a number entered in Product Record > Location: StringToFloat(STOCK.LOCATION) * STOCK.QTY_IN_STOCK 
 
 StringToInteger( variable ) - Converts alphanumeric fields to numeric fields for use in expressions and filters, when the fields contain whole numbers. 
 
 E.g., To multiply the quantity in stock by a number entered in Product Record > Unit of Sale: StringToInteger(STOCK.UNIT_OF_SALE) * STOCK.QTY_IN_STOCK 
 ** All records must have a number entered in the appropriate format, there are any non-numeric values, blank fields or whole numbers the following message appears: 'Input string is not in correct format.' 
 I hope this helps 
 Regards, 
 Fiona, Sage UKI

Sage 50 Accounts

How to us Web_Category_2 as a number for calculations

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING