using the COUNT function with 2 criteria in INFOPATH 2013 - InfoPath Dev
in

InfoPath Dev

using the COUNT function with 2 criteria in INFOPATH 2013

Last post 02-22-2018 10:42 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 02-22-2018 09:46 AM

    using the COUNT function with 2 criteria in INFOPATH 2013

    Reply Contact

    I want to count the number of instances where the Status is ACTIVE and the Type is RISK.  I have count(Status[.="ACTIVE]) which works fine but how do I add the second criteria Type = "RIsk"?

  • 02-22-2018 10:42 AM In reply to

    Re: using the COUNT function with 2 criteria in INFOPATH 2013

    Mark as Answer
    Reply Contact
    When you select the field for your count function, in this case Status, you added a filter for Status = Active. Modify the filter to include Type = Risk. Attach your form to a reply under the Options tab if you need a hand. :)
    Hilary Stoupa
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.