Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ilya Rabyy
  Where is Ilya Rabyy?
 Fountain Valley
 California - United States
 Ilya Rabyy
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: Rounding an AVG for totals - HOW TO?
Thread ID: 188962 Message ID: 188988 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Tuesday, August 12, 2008 9:52:22 PM         
   


> >
> > Shows "****" instead of " 90".
> > I tried TRANSF(Pct_Fld, "@RZ 999"), TRANSF(Pct_Fld, "@RZ 99"), and even TRANSF(ROUND(Pct_Fld, 0), "99") - same effect: four stars.
> >
> > Regards,
> >
> > Ilya
>
> The stars mean there's insufficient room, probably because of leftside spaces:
> LTRIM(TRANSFORM(number,'999,999.99')
> You may have to widen the textbox somewhat.
> -Anders

Tried that latter too, the result was the same: 4 stars. (BTW, since it's percent, there can be no more than 3 digits in the integer part. Why it showed 4 (four) stars - eludes my comprehending.)

Regards,

Ilya

ENTIRE THREAD

Rounding an AVG for totals - HOW TO? Posted by Ilya Rabyy @ 8/12/2008 7:54:27 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Anders Altberg @ 8/12/2008 7:58:15 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Ilya Rabyy @ 8/12/2008 8:42:07 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Anders Altberg @ 8/12/2008 9:29:56 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Ilya Rabyy @ 8/12/2008 9:52:22 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Yuri Rubinov @ 8/12/2008 8:18:41 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Ilya Rabyy @ 8/12/2008 9:04:29 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Yuri Rubinov @ 8/12/2008 9:27:40 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Ilya Rabyy @ 8/12/2008 9:59:50 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Yousfi Benameur @ 8/12/2008 9:56:35 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Ilya Rabyy @ 8/12/2008 10:05:39 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Yousfi Benameur @ 8/12/2008 11:19:38 PM
RE: Rounding an AVG for totals - HOW TO? Posted by Ilya Rabyy @ 8/13/2008 5:02:30 PM