How to sum based on values from a drop down list inside a repeating table? - InfoPath Dev
in

InfoPath Dev

How to sum based on values from a drop down list inside a repeating table?

Last post 07-20-2013 05:24 PM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 07-19-2013 03:16 PM

    How to sum based on values from a drop down list inside a repeating table?

    Reply Contact

    I have a repeating table with the following fields. Date, StartTime, EndTime, TotalHours, RegOrOT (dropdownlist).  THe drop downlist has 2 options.. Regular and Overtime.

    In the footer I have two fields (Regular hours total and Overtime hours total) 

    I want to sum the value of all the Regular TotalHours in one  field and Overtime Hours in another feild.  How can this I achieve this?

  • 07-20-2013 05:24 PM In reply to

    Re: How to sum based on values from a drop down list inside a repeating table?

    SurvivalKnife.xsn
    Mark as Answer
    Reply Contact

    you can add a calculated value with an Fx function of sum(TotalHours) where field is filtered by the dropdown list.

    attaching a sample for your survival

     

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.