none
The expression is not a node-set ???

    Question

  •  

    I'm new to Infopath 2007. I created a simply view, which consisted of 3 textbox as follows:

     

    - txtNumber1

    - txtNumber2

    - txtTotal     --> This textbox is a result of calculating of (txtNumber1-txtNumber2)/txtNumber2

     

    The problem was when I clicked on the Verify Formula button , it showed as below

     

    The expression is not a node-set.

    --> (../my:txtNumber1 - ../my:txtNumber2) <-- / ../my:txtNumber2

     

     

    Any idea? any help?   I will appreciate

     

     

    Monday, January 14, 2008 6:13 PM

All replies

  •  hutchbrew wrote:

     

    I'm new to Infopath 2007. I created a simply view, which consisted of 3 textbox as follows:

     

    - txtNumber1

    - txtNumber2

    - txtTotal     --> This textbox is a result of calculating of (txtNumber1-txtNumber2)/txtNumber2

     

    The problem was when I clicked on the Verify Formula button , it showed as below

     

    The expression is not a node-set.

    --> (../my:txtNumber1 - ../my:txtNumber2) <-- / ../my:txtNumber2

     

     

    Any idea? any help?   I will appreciate

     

     

     

    Are you using the sum() or avg() function anywhere and haven't shown it here? What is the structure of the nodes in your main data source. The expression should work.

     

    Try

     

    Code Block
    (../my:txtNumber1 - ../my:txtNumber2) div ../my:txtNumber2

     

     

    and see if that works.

     

    Tuesday, January 15, 2008 12:02 AM