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

Q: 0.0 not right-unligning under other percentages

Status
Not open for further replies.

carynbo

MIS
Feb 11, 2003
57
US
Has anyone experienced the following, and if so, has a solution been found?

I have a formula for a percent field:
if Sum ({%Fld1}) = 0
then 0
else (Sum ({%Fld2})/Sum ({%Fld1}) * 100)

I display it in a right-justified field custom-formatted as:
Decimal 1.0, Rounding 0.1, Leading Zero,
Show Zero As: 0.0

The problem is that values of 0.0 do not properly right-align under values of non-zero percents - that is, values of 0.0 shift a little over to the left.

Anyone else ever experience this?

Thank you for any insights. Caryn

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top