Hello,

I am trying to create a line graph that displays projected expenditures along with actual expenditures. These values are contained in two different SharePoint lists. I want the Chart to display the SUM of the actual expenditures for a each month and display both actual and projected values as dollars.

I cam across this example from a NEVRON KB article, "Chart From Multiple SharePoint Lists". After a few attempts I was able to get the data source to display the data, however the data for the actual and projected expenditures are displayed as text rather than numbers. I have not been able to find the right formula that will sum the total actual expenditures for each month. No mater what formula I enter I receive an error that the data is not in the correct format, which goes back to the SharePoint Site Query not displaying the data in the correct format. Below are my entries to the data source CAML:

List CAML:






View Fields CAML:



Here is the formula I ma using to try and display the data:

=SUM(FORMAT(Fields!Expensed), "C", "en-us")


Any help anyone can provide will be greatly appreciated

Jessey