5 Replies Latest reply on Oct 9, 2009 6:30 AM by pguerett

    If statements

    Jannae72 Level 1
    Jannae72 Oct 7, 2009 4:28 PM

      Morning,

       

      Trying to do another 'If' statement but I can't seem to get the first part of the formula to work.  The first line is still being divided by 2.

       

       

      if

       

      (Table3.Row3.Cell1.rawValue == null ) {

      this.rawValue

      = (Table3.Row2.Cell8.rawValue) / 1;

      }

       

      if

       

      (Table3.Row4.Cell2.rawValue == null) {

      this.rawValue

      = (Table3.Row2.Cell8.rawValue + Table3.Row3.Cell8.rawValue + Table3.Row4.Cell8.rawValue) / 2;

      }

      else

       

      {

      this.rawValue

      = (Table3.Row2.Cell8.rawValue + Table3.Row3.Cell8.rawValue + Table3.Row4.Cell8.rawValue) / 3;

       

      Any assistance would be awesome.

       

      Cheers

       

      Jenny

      • 1041 Views
      • Tags:
        • 1. Re: If statements
          pguerett Level 6
          pguerett Employee Oct 8, 2009 5:42 AM (in response to Jannae72)

          Your code is confusing me .....can you describe what you expect your code to do?

           

          Thanks

          Paul

          • 2. Re: If statements
            Barum55 Level 1
            Barum55 Oct 8, 2009 6:09 AM (in response to pguerett)

            Hi Paul, you're my last hope! I cannot get my text boxes to increase in depth as I enter data - I just get the scroll bar coming into play. Fine if it is purely an electronic form but obviously no good if a printed copy is required. Under Form Properties I've entered 'Interactive Form' and Acrobat 8 (Dynamic) XML form. I've ticked 'Allow multiple lines' in the object pallette, ticked 'expand to fit' in the height (y) layout pallette and have my subform as flowed. This is my last throw of the dice. I attach an example form with text box.

            Yours pleading

            Barum55

            • 3. Re: If statements
              pguerett Level 6
              pguerett Employee Oct 8, 2009 6:13 AM (in response to Barum55)

              There is no attachment here ....you cannot simply attach to the email ....you have to click on the link an interact through the BBS software.

               

              Paul

              • 4. Re: If statements
                Jannae72 Level 1
                Jannae72 Oct 8, 2009 4:27 PM (in response to pguerett)

                Hi Paul,

                 

                There are three stages to this:

                 

                1.     If a person fills out the first row then the 'Total Average Interview Score' cell will be just the first row 'Total' cell

                2.     If a person fills out the first and second row then the 'Total Average Interview Score' cell will be the first and second row 'Total' cells divided by 2

                3.     If a person fills out all three rows then the 'Total Average Interview Score' cell will be the sum of the first, second and third row 'Total' cells divided by 3.

                 

                I have attached another sample.

                 

                1.     The first block, the 'Total Average Interview Score' should be 12

                2.     The second block the  'Total Average Interview Score' is correct at 15.

                3.     The third block the 'Total Average Interview Score' is correct at 18.

                 

                Therefore I am not able to get the first block to = 12 with my coding.

                 

                Hope this makes sense.

                 

                Jenny

                • 5. Re: If statements
                  pguerett Level 6
                  pguerett Employee Oct 9, 2009 6:30 AM (in response to Jannae72)

                  Not sure if I followed all of that but this is what I think you want ....have a look and let me know.

                   

                  Paul