0 Replies Latest reply: Oct 9, 2012 11:21 AM by Tahir Ghalib RSS

    And condition between two Input boxes

      Hi,

       

      I have attached a sample file now.

       

      Here is little description of the file.

       

      It contains 5 fields, out of these 5 three of them are Comments Posted (CP) in 4 weeks, 26 weeks and in 52 weeks.

      Created Input boxes for CP 4 weeks and 26 weeks. These input boxes have two variables each (signs and values). Later I will include for 52 weeks as well.

       

      I want to create a table chart based on these input boxes.

      Expression should fulfill all (and) the conditions of the input boxes. For example I want expressions for 4 weeks and 26 weeks like

      "CP in 4 Weeks >= 4 and CP in 26 Weeks <=10"

       

      How can I write an IF condition for expression which fulfull the both input boxes conditions.

       

      Can someone write these expression?

       

      Please let me know if something is not clear.

       

      Thanks,

       

      TA