formula for repeating table - InfoPath Dev
in

InfoPath Dev

formula for repeating table

Last post 08-31-2007 10:10 AM by iacob_alin. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-14-2007 09:01 AM

    formula for repeating table

    I am trying to write the formula for a text box field in my form. The formula is based on values that get inserted into a repeating table. 

    The formula that I want to get working is the following 

    sum (colA * colB)  where colA and colB are fields that get added to the repeating table as each row gets added. 

    The error that I get with this formula is "Argument 1 must return a node-set."  Does anyone know a trick to get around this? 

    Thanks

  • 08-20-2007 07:38 AM In reply to

    Re: formula for repeating table

    put a third field colC into your repeating table. use this function to get the value for colA * colB: number(colA) * number (colB). then on the field you wanna have the sum use sum(number(colC)). does this work ?

    Listen to Motörhead cos they play Rock'n Roll :)
  • 08-31-2007 10:10 AM In reply to

     

    Hello,

    You can do this by using the following formula.

    sum(eval(Product, "my:value"))

    Where:

    Product is the repeating table name and my:value is the field value that you whant to calculate.

    I've attached a form template with this example.

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.