Re: NaN error on avg calculation

Hilary Stoupa — Sat, 02 Nov 2013 14:20:38 GMT

Hi - does the NaN (Not a Number) error persist if you fill in some values in the fields that you are averaging? Here's a link to a blog post that may be of help in that case: http://www.braintrove.com/id/71

NaN error on avg calculation

Mauricegetsit — Tue, 29 Oct 2013 20:16:10 GMT

I created an InfoPath 2010 interactive form. I created a calculation value using avg. I have a sections for percentage completed. Each section I have a whole integer field for percentage complete. For example, section 1 has a percentage complete, section 2 and so on. I want and average of the full part (which has three to four sections. So I group all four sections together and named the group PercentageCompleted. I set a variable then an average calculated field. I grouped the percentage completes into a group “PercentageComplete”. To calculate an average I write avg(PercentageComplete) when I check it I had/have no errors. Yet when I preview and even in form filler mode I get “NaN”. When I hover over the field I get “Only with Integer” enclosed in a box of red dash lines.Please offer some good advice.

General

Re: NaN error on avg calculation

NaN error on avg calculation