I am trying to use the Summary Widget in Dashboard to show the sum of an attribute field either in a queries data set or the total dataset prior to running any queries. All seems to work fine, but the sum function. It seems to show the correct total in the preview window during configuration, but when the value is not right in the dashboard widget. The same is the case when using the "sum" function in the other Widgets such as Pie Chart or Bar Chart.
Any comments or thoughts on what the issue could be would be much appreciated.