Summing Results from Multiple tables - InfoPath Dev
in

InfoPath Dev

Summing Results from Multiple tables

Last post 05-01-2006 08:17 AM by Anuma. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 05-01-2006 07:27 AM

    Summing Results from Multiple tables

    I have 2 separate repeating tables in a repeating section. Each table contains subtotals in their footers(which work fine). How do I create a grand total that sums the 2 subtotals?
    I am currently trying the following expression (in which each of these items is an expression)
    my:StandardLaborEst/my:CurLaborCostTotal + my:StandardODCEst/my:CurExpCostSubtotal
    Dean
    Charlotte, NC
  • 05-01-2006 08:08 AM In reply to

    Re: Summing Results from Multiple tables

    What happened? Is your solution not working or are you looking for a better solution?

    Please give more details about your XML.
  • 05-01-2006 08:10 AM In reply to

    Re: Summing Results from Multiple tables

    No errors shown, just getting no results in the Grand total calculation. The subtotals show results but the grand total does not update and just shows $0
    Dean
    Charlotte, NC
  • 05-01-2006 08:17 AM In reply to

    • Anuma
    • Top 25 Contributor
      Female
    • Joined on 07-20-2005
    • India
    • Posts 525

    Re: Summing Results from Multiple tables

    Hi,
    1. Select Expression box in the Controls Task pane.
    2. Click on “fx” button in the Insert Expression box.
    3. Enter Sum(Field1)+Sum(Field2)
    4. Click on ok.

    Field1 is the column in First repeating table.
    Field2 is the column in Second repeating table.

    Anuma Chinthapalli /
    http://www.GGKTech.com
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.