11-24-2009 04:22 PM
I wish to alter the properties field in a report, I did manage to have the report run without the $ sign one time then the report corrupted with a GUID error. The data expression I wish to change is Format(Total1, "Currency") & Format(Sum(Total1), "Currency") I do not wish for the report to produce the $, any suggestions. If I alter the statement to much it does not function at all, if I replace it with a new field it does not calculate properly.
I have read a variety of posts that discuss the lack of variable structure for the Opportunity area. We are also using it for keeping track of something other than its original design we use it for Accreditation points, to have more flexibility in the way opportunities presents would be great, in the mean time if I can get reports as requested above it will make our lives easier.
11-25-2009 09:45 AM
11-25-2009 02:33 PM
Roy is right you should try to use the custom field first. If you need additional granular control use VBScript.
You need to be aware of rounding too when you use the format function. If you want to try, give this a
Format((Total1),"#,###.##") and Format((Sum(Total1)),"#,###.##")
11-25-2009 02:46 PM