Cannot sum not numerical data

Applications Grid / Reports
#1

Trying to generate code for a grid with a few sums… Getting the error:

Cannot sum not numerical data (check1, check2, check3)

Each of those (check1, check2, check3) are listed as “Integer” Datatype in “Edit Fields.” Last time I checked, Integer is numerical… any ideas what I’m doing wrong?

Thanks!

#2

I have the same problem, with a Currency “Data Type”. Any idea/solution to this problem?

L.E. I noticed that “SQL Type” for this field was not set, so I suspect this was the problem. To solve the problem, I had to create a new grid from scratch and manually copy all settings. Nasty thing, but at least I got rid of the problem!