Count if > 0 of field in Repeating Table - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Count if > 0 of field in Repeating Table

Last post 05-15-2023 07:46 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-14-2023 04:45 PM

    Count if > 0 of field in Repeating Table

    Hi All, Haven't engaged with Infopath in a long time and have been faced with an issue on an old form but for the life of me, I am struggling to recall my skills in Infopath ! I have a repeating table and a textbox which does account per repeated section. The issue we have is, the first entry in a repeated section counts as 1 even if the entire section is blank, this is generating incorrect stats. I want to be able to update the string to count only if if a field is not blank. Example Current: count(Customer) Want it to be count(customer) > 0 Can anyone steer me into how I can do this? I've tried to find it on this forum and through Google but having no luck, would greatly appreciate any guidance.
    Filed under:
  • 05-15-2023 07:46 AM In reply to

    Re: Count if > 0 of field in Repeating Table

    I've attached a simple sample for you. Right click the linked file and save the file locally. Right click the locally saved file and select design to open in design mode (if Windows 11, I think there is a more options menu option you need to select). Then preview. Basically, when you select the repeating group for use in your count formula, you can then use the Filter Data button to add a filter to only count if Customer is not blank or zero or whatever :)
    Hilary Stoupa

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