### Title

Multiple Calculation Field

### Post

Here's my problem

I have a qty field, unit price field and extended total field.

My unit price field is a value list drop down of "msi, feet, sheets"

I want my entended total field to do this:

If the unit price is "msi" then take the unit price divided by 1000 times the qty.

If the unit price is "feet" then take the unit price times the qty.

And if the unit price is "sheets" then take the unit price times the qty.

I want this calculation in my entended total field, not in a script.

Any clues!

BTW: This forum is amazing! Thanks for all of the help!

_ Robin

unit price * qty / Case ( unit type = "msi"; 1000; 1 )