Sumif in Infopath (Sum a field meeting a criteria) - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Sumif in Infopath (Sum a field meeting a criteria)

Last post 07-02-2016 04:59 AM by Edwin Brito. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-02-2016 04:41 AM

    Sumif in Infopath (Sum a field meeting a criteria)

    Hi, I'm working on a Expense Report form in InfoPath, and I need to sum a field in a repeating table meeting a criteria -Déjà vu- I need to sum the 'Amount' only when the 'Payment' = "Personal Funds" Last time I had that problem, I used the Sum and Eval functions. So far this is the formula I have: sum(xdMath:Eval(../my:group2/my:group3/my:Payment[. = "Personal Funds"], ../my:group2/my:group3/my:Amount)) This is the error I'm receiving: Type mismatch. Error occurred during a call to property or method 'Eval'. Can you guys help me come up with the right formula syntax?
    EB
  • 07-02-2016 04:59 AM In reply to

    Re: Sumif in Infopath (Sum a field meeting a criteria)

    I found it!! sum(xdMath:Eval(../my:group2/my:group3[my:Payment = "Personal Funds"], "my:Amount"))
    EB
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.