How do I make the Column Total not show **** in a report but show the actual sum?

This message has been edited. Last edited by: Tamra,

The columns you are totalling have overflowed.

Please increase the size of the format of the fields.

what are the field formats that you are totalling ?

How do I increase the size of the format of the fields?

You can temporarily change the field format.
If you are using Dev. Studio Right click on the field that is having the problem and click format and change the format.

Manually it would look like sales in the example below.


TABLE FILE CAR
SUM
SALES/I11
BY LOWEST COUNTRY
BY LOWEST CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

Thank you so much. I do not have Dev Studio so I've sent the request to our BI team to help with.

Are you not a developer?

Officially no, but do some development. I just don't do enough to have Dev Studio. I am working in InfoAssist right now. Thanks again for your help.

OK,
You still should be able to do this yourself. I don't normally use Info Assist. You should be able to find this info under the HELP documentation.

If you've not been to training, I would suggest that.

Here's what I found:

Procedure: How to Assign a Numeric Format
With a report open in Live Preview, right-click a virtual or column Measure field, and select Edit Format.
The Field Format Options dialog box opens.
From the Field type list, click one of the following options:
Floating Point (default length 7.2)
Integer (default length 5)
Decimal (default length 12.2)
Packed (default length 12.2)
If the selected field matches the selected format type, its current length appears in the Field Length field. Otherwise, the default length appears in the Field Length field. The Decimals field shows the numbers of decimal places for Floating Point, Decimal, and Packed.
To assign a different length, specify it in the Field Length field for format types as follows: 1-9 for Floating Point, 1-11 for Integer, 1-20 for Decimal, and 1-33 for Packed.
To assign a different number of decimal places for Floating Point, Decimal, or Packed, specify the number in the Decimals field.
Click OK to close the Field Format Options dialog box and return to the Results panel.
The new format appears in the previously selected column.

Perfect! Thank you so much!