Controls

Re: Expression boxes not calculating total fields

Travis Regensburger — Tue, 10 Jun 2008 18:01:08 GMT

Thanks Clay, I will give that a try and see if I can isolate it.

Makes you feel like you are going crazy!

Re: Expression boxes not calculating total fields

Clay Fox — Tue, 10 Jun 2008 16:09:30 GMT

I would create a test view that shows all of the data or a range that is in InfoPath.

Expression boxes can be good since you can see it without formatting.

Then see is you can find the bad data. You could create a calculation field for each row that could help flush out the data field.

Expression boxes not calculating total fields

Travis Regensburger — Tue, 10 Jun 2008 00:28:29 GMT

I have a form that is connected to one table in an Access database. The fields in question are all formatted as Number fields (double) in the database.

I am doing aggregate (sum, etc) formulas via expression boxes on the fields returned. Depending on the values used to filter the data in the query section (these fields are used to select the proper group of records, no calculations are performed using these fields), I receive either a correct result in the expression box or 1.#QNAN. This would lead me to believe there is an entry in the database that is causing the issue, but I have searched the database and there are no values that might be causing the issue (no negative numbers, no zeros, etc). Is it possible InfoPath is still treating a value as a text or some similar situation?

Thanks in advance...

Travis