5 Replies Latest reply on Aug 27, 2013 9:19 PM by 41globalit

    How to ignore a dropdown field that contains value "N/A"?

    dklbwf

      Hello Adobe Fam,

       

      Have a client that I have built a simple form for that does basic calculations.  There are 6 dropdowns that all contain N/A, 1, 2, 3.  And at the end a overall average is calculated from these drop downs.  client is wanting to totally ignore any drop downs that contain N/A meaning if N/A is in 2 of the 6 dropdowns then a average should only be calculated on 4 drop downs.   I am just lost on the logic or if statement needed to tell the total field to ignore a certain drop down field if user has selected N/A....

       

      Thanks N Advance for any help!