### Title

Auto-Enter Multiplication Product Question

### Post

I'm new to fm, and am trying to create a field that is the product of simple multiplication in another field, basically something along the lines of 3x5 in the first field, and 15 automatically populating into the next field.

I attempted to go under management, change the field to "calculation" (right now it's "text"), and when it brings up the next window typed =PRODUCT and double-clicked the field where the 3x5 is entered, when I click ok it kicks up a warning about needing " (which I've added and it still gives me the same warning)?

One more variable I ned to mention is the 3x5 field is occasionally text only instead of numbers, will this create more problems than I'm trying to solve?

Thank you in advance for any assistance

Mixing text and numbers in a field when the numbers have to be treated as numbers is generally not a good idea. You may even want three fields, the third for cases where you enter just text.

But to use evaluate, you might use this expression:

Evaluate ( Substitute ( YourTable::YourTextField ; "x" ; "*" ) )

You enter this expression into YourTextField and a different field with the above expression will compute and display the area.

If you set this up as an auto-enter calculation, be sure to clear the "do not replace existing value" check box.