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

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