https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/116797.aspxMon, 24 Jul 2017 15:16:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116797Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/116797.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116797Use translate. So: translate((your calc goes here), "Na", "") will remove NaN.https://www.infopathdev.com:443/forums/thread/116777.aspxThu, 20 Jul 2017 15:17:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116777arvindraj850https://www.infopathdev.com:443/forums/thread/116777.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116777Hello - 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?