Trying to get a single table query to sum on a field. When I click "sum" as the View and move to select a field all I get is the table name (custusage in the screen shot) and no option to select anything. There are numeric values available. Any ideas?
Strange.
Is it possible that that data is being stored as strings? Check in the Admin panel -> Metadata -> “Show original schema” and see if things look right. We should be picking up all the numerical values.