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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to format the summarized field in cross tab

Status
Not open for further replies.

CrystalUser1

Programmer
Sep 16, 2004
138
US
Hi,

I have to format the summarized field which is number type in cross tab.

I have to format the summarize the field based on the certan conditon like the following:

if type=count, then 9,999,999
if type=percentage, then 99.9

thanks in advance.
 
Just right click on the summary->format field->number and choose -1123 for the count. Do the same for the percentage and select "Customize"->decimals: select 1.0 from the dropdown.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top