Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Format in Charts show decimals

Status
Not open for further replies.

RickUllrey

IS-IT--Management
May 20, 2001
3
US
I am using CRW 8.0. I use the Year(database.field) function to separate data in columns on a Cross Tab report. The report is fine and the column headings are in whole numbers. However, when I generate a graph the column labels have pesky decimals added. I have tried to reformat the labels in the Chart Analyzer, but there is no option for number formats.

Is there a formula qualifier, like "round" that will eliminate the decimals.

Thanks for the help. This is probably a little deal, but I have invested heavily in it.
 
not sure if this will help, but there is round in CR
Round(2345.23456,0)
«Returns 2345.»
look in the help file for more examples
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top