NaN error on avg calculation

Last post 11-02-2013 07:20 AM by Hilary Stoupa. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

10-29-2013 01:16 PM

Mauricegetsit
Joined on 09-16-2013
Posts 2

NaN error on avg calculation

Reply Contact

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.

Filed under: Calculation, average, NaN, avg

11-02-2013 07:20 AM In reply to

Hilary Stoupa
Joined on 06-20-2008
Posts 13,297

Re: NaN error on avg calculation

Mark as Not Answer Mark as Answer ...

Reply Contact

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

Hilary Stoupa

Page 1 of 1 (2 items)

InfoPath Dev