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/74817.aspxWed, 01 Feb 2012 20:12:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:74817karson60https://www.infopathdev.com:443/forums/thread/74817.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=74817<p><font size="3" face="Times New Roman">The default formula wouldn&#39;t work - InfoPath didn&#39;t like the syntax so I went with hiding the field.&nbsp; Thanks for your help.</font></p>https://www.infopathdev.com:443/forums/thread/74814.aspxWed, 01 Feb 2012 19:35:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:74814Jimmy0https://www.infopathdev.com:443/forums/thread/74814.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=74814<p>How about hiding the ValuePerUnit field on the condition ValuePerUnit = &quot;NaN&quot;?</p> <p>&nbsp;Another option would be to use the default value formula <strong>TotalLand / (TotalUnits + (TotalUnits = 0))</strong> which should result in a value of <strong>0</strong> if TotalLand and TotalUnits are both 0.</p>https://www.infopathdev.com:443/forums/thread/74812.aspxWed, 01 Feb 2012 19:04:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:74812karson60https://www.infopathdev.com:443/forums/thread/74812.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=74812<p>I have a field called ValuePerUnit which has a default value of TotalLand/TotalUnits.&nbsp; Total Land and Total Units are derived by respective sums of rows in a repeating table.&nbsp; When I first open the form, the ValuePerUnit field displays NaN in it.&nbsp; I know this is for Not a Number but what can I do so this doesn&#39;t display?&nbsp; It goes away as soon as data is entered in the a Unit field.</p> <p>Thanks!&nbsp;</p> <p>&nbsp;</p>