1 Reply Latest reply on Mar 7, 2014 12:06 PM by MJ2014

    Cross calculation question for Print Media Form

    MJ2014

      Please see eclosed diagram of my form. I offer multiple options for print media, each with their own unique price. When you select the paper type (call it "cell 1")  it automatically inserts the price in another cell (cell 2). I then need to take the total square inches (cell 3) and multiply them by the price in cell 2.

       

      I've tried writing a script to find the value by multiplying price (which changes when the paper type is changed) by the total square inches in cell 3 but I cannot get it to work. Ideas?calculation_field.jpg