AnsweredAssumed Answered

Multiple Calculation Field

Question asked by mgxdigital on Sep 10, 2009
Latest reply on Sep 10, 2009 by mrvodka

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

Outcomes