Simple formula error

Hi,

I am making an app that allows for order creation. One of my forms allows a remote salesman to create a new order, with a unique ID for a customer.

When products or services are added to the order they are pulled from the parent Products/Services tables and their Value in GBP is added to a hidden field.

Another field allows the salesman to specify the number/count of each item on the order.

So if product A is chosen, the value of �100.00 gets added to the hidden field and I want to multiply this by the number added to the Count field.

I want to do this as a formula.

in the formula creation box I supply a name for the formula and type my code like this:

Count * Prod_Value

but i get the error -

Encountered "*" at line 1, column 7.
Was expecting:
"(" ...

Its like the operator is invalid? Any help would be appreciated.

I have also just tried making the field type that holds the values a DECIMAL rather than a CURRENCY field in case the * operator was not valid for CURRENCY and this produced the same error.