Infopath - Avoid NaN errors on Calculation - InfoPath Dev
in

InfoPath Dev

Infopath - Avoid NaN errors on Calculation

Last post 07-24-2017 08:16 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-20-2017 08:17 AM

    Infopath - Avoid NaN errors on Calculation

    Hello - I have two secondary data sources (lists) that are imported into a separate list. These data sources return multiple rows of data based on a specific criteria . If the data is not available, they return blank rows. When I do a summation / calculation on the blank rows, I get an NaN errors. These NaN errors affect my total calculation. Is there an IFERROR return "0" calculation that we can use in Infopath?
    Filed under: ,
  • 07-24-2017 08:16 AM In reply to

    Re: Infopath - Avoid NaN errors on Calculation

    Use translate. So: translate((your calc goes here), "Na", "") will remove NaN.
    Hilary Stoupa

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