How to us Web_Category_2 as a number for calculations

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

  • 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