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/105819.aspxWed, 16 Mar 2016 11:51:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105819Richard Bangr0https://www.infopathdev.com:443/forums/thread/105819.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=105819I found the answer in this post: http://www.infopathdev.com/forums/p/9602/33953.aspx#33953 Thanks anyway!https://www.infopathdev.com:443/forums/thread/105818.aspxWed, 16 Mar 2016 11:43:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105818Richard Bangr0https://www.infopathdev.com:443/forums/thread/105818.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=105818Hello All, I searched all the resources i knew in order to find an answer to this but, i couldn't find anything, so here goes: I need a calculated field that does a conditional AVG. Here's the scenario: I have 4 fields, with a default value of "N/A" A=N/A B=N/A C=N/A D=N/A I need field called AVG that does the average between A,B,C and D. If all fields have values then there is no problem, but if A,B and C have values and D is the default ("N/A") then my average is screwed up. Any ideas?