Calculation from Value List Text String

[Chuck J]

There are three fields involved.

1. Operation (Value List)Text Field

2. Hours (Number of hours a worker spent on the operation)Number Field

3. Operation Cost (Hours X Operation Cost)Calculation Field

The Operation field is using a Value List of operations with the hourly cost of the operation the last word of each text string.

710-10 - Design 114.00

710-11 - Web/Html 110.00

710-12 - Disk Preparation 088.00

710-13 - Illustration 109.00

710-14 - Scanning 090.00

In the calculation field I need to pull out the last word from the Value List in The Operation(114.00 or 110.00 or 088.00 or 109.00 or 090.00(this is the rate charged for the operation))depending upon which operation is selected from the value list.

Then multiply this number by the number of hours entered in the "Hours" field.

Rather than show you my failed attempts using RightWords, Count and numerous other functions, what should I be doing in the Calculation Field?

Do I need the 088.00 format or could I just use 88.00

[Kent Searight]

Use:

RightWords (operationField;1) * hours

Make sure your calculation result is a number.