05-12-2010 02:00 PM
I wanted the opportunity quantity to show up on an Opportunity by Status report and got it to do that and created a summary field as well to total them and put them at the top of the report along with the other totals.
I know you are supposed to be able to right click the field and based on the typr of field (text, number, currency, et. al) you have choices about how the field will display. Apparently the Quantity field in Opportunities is a Currency Field. Not sure I understand that as it multiplies times $ amounts in an opporunity to CREATE a currency amount but is clearly a number...not a currency. So...can't get it to display with commas as described below.
A Number field can be displayed with the following options:
Any ideas here? I had this in another report as well and though that one is a number field can't get it to display as I wish.
05-13-2010 08:32 AM