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,
WebFOCUS 8.0
February 09, 2015, 05:02 PM
Waz
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 ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
February 10, 2015, 07:00 AM
Thias Mercer
How do I increase the size of the format of the fields?
WebFOCUS 8.0
February 10, 2015, 08:48 AM
Msondra
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
WebFOCUS 8.1.05 Windows, All Outputs
February 10, 2015, 09:53 AM
Thias Mercer
Thank you so much. I do not have Dev Studio so I've sent the request to our BI team to help with.
WebFOCUS 8.0
February 10, 2015, 10:09 AM
Msondra
Are you not a developer?
WebFOCUS 8.1.05 Windows, All Outputs
February 10, 2015, 10:34 AM
Thias Mercer
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.
WebFOCUS 8.0
February 10, 2015, 10:59 AM
Msondra
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.