5 Replies Latest reply on Sep 10, 2009 4:22 PM by mrvodka

    Multiple Calculation Field

    mgxdigital

      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